Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / praveen
You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the session task and command task?
How to do unit testing in informatica?
Describe data concatenation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What differs when we choose the sorted input for aggregator transformation?
Why update strategy and union transformations are active?
What are active and passive transformations?
Where can we find the throughput option in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are multi-group transformations?
What is data movement mode in Informatica and difference between them?
What are the different ways to implement parallel processing in informatica?