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
- 19313 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 are the designer tools for creating transformations?
4 yrs etl devloper roles and responsibilities?any body give solutions
How to Create a folder using pmrep command?
What are the different types of olap? Give an example?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Why sorter is an active transformation?
Can we override a native sql query within informatica?
What do you mean by blocking transformation?
what is the Default Source Option For Update Strategy Transformation?
What is meant by pre and post session shell command?
Enlist some properties of sessions.
How to generate sequence numbers?
What do you understand by a term domain?
What is the benefit of partitioning a session?
What are the types of schemas we have in data warehouse.
