If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
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
Explain the features of connected and unconnected lookup.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are different types of transformations available in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
How to generate sequence numbers using expression transformation?
What are the main issues while working with flat files as source and as targets ?
Write the advantages of partitioning a session?
What are the different lookup cache(s)?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the difference between STOP and ABORT options in Workflow Monitor?
What is decode in informatica?
What is confirmed fact in dataware housing?
How can you differentiate between powercenter and power map?
What are the components of Informatica? And what is the purpose of each?
Define mapplet?