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
- 18895 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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How many ways are there to create ports?
What are the differences between a connected lookup and unconnected lookup?
How does the aggregator transformation handle null values?
Please let me know how to make Data masking in informatica..
pmscmd startworkflow -sv
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is joiner change?
Performance tuning( what you did in performance tuning)
r u done any partitions in ur project?
What is meant by target load plan?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is workflow manager?
What is a connected transformation?
Enlist the various types of transformations.
