we have 20 records in source system, when we run for the 1st
time, it should load only 10 records into the target, when
you run for the second time it should load another 10 record
which are not loaded. How do we do that? Can we write a SQL
query in source qualifier to do it. This q' is asked in one
f the interviews. Please let me know if anyone knows. Thanks
Answer Posted / suresh
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> num >= MVar1 and num <=MVar2
Mvar1 and MVar2 are assigned with the value of 1 and 10 respectively
in EXP=>V-port - setvariable(mvar1, 10)
V-port - setvariable(mvar1, 20)
after the execution of the mapping 10 and 20 values are stored in the mvar1 and mvar2 into the repository
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
is it possible to index the data in cache of lkp transformation ?
What is a repository? And how to add it in an informatica client?
What differs when we choose the sorted input for aggregator transformation?
what is the hint? how to use it to reduce the query processing in program?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What does command task mean?
How to Create a folder using pmrep command?
Enlist few areas or real-time situations where informatica is required.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is joiner transformation in informatica?
What are the features of complex mapping?
What is the Rank index port in Rank transformation?
Briefly describe lookup transformation?