Interested to Buy Any Domain ? << Click Here >> for more details...
If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
- 5 Answers
- 18940 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mohit
After running the session once it will load 10000 records
and it will fail afterwards then we can take the minimum
and maximum count of the number of records in the target in
a paramter and we can specify these parameters in the SQl
override of sql qualifier so once again when it will run
the session then it will take those minimum and maximum
values from the parameter and will specify a condition in
the sql overide that dont take any values from min to max
and take rest of the values so in this case the minimum
will be 1 and the maximum will be 10000 so the sql overide
will take the values after 10000 i.e 10001.
select * from employee where value is not in between $$min
and $$max
I think may be this can be a solution
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is decode in static cache?
What is repository manager?
How to create Target definition for flat files?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What the difference is between a database, a data warehouse and a data mart?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the different lookup cache(s)?
if we have a delimiters at unwanted places in a flat file how can we over come those.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Design a mapping to load a target table with the following values from the above source?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Define mapplet?
Explain Dataware house architecture .how data flow from intial to end?
What is the need for an etl tool?
