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
- 3 Answers
- 7353 Views
- TCS, I also Faced
- E-Mail Answers
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
How to do the error handling of if ur source is flatfiles?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can we remove the duplicates from flat file source?
How can we use mapping variables in informatica?
What are the types of caches in lookup? Explain them.
What is union transformation in informatica?
Define the various join types of joiner transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain direct and indirect flat file loading (source file type) - informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the features of connected and unconnected lookup.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is aggregator transformation in informatica?
