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 / babu
Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)
NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.
after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.
Thanks,
Babu
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is meant by incremental aggregation?
How can we store previous session logs?
What are the components of the workflow manager?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Which development components of informatica have the highest usage?
What is the reusable transformation?
Target increases every day even though no new record was inserted
How to load a Dimension ? and how to load a fact table?
Parameter and variable differences
What are the different versions of informatica?
what is the difference between informatica6.1 and infomatica7.1
What is meant by pre and post session shell command?
What is complex mapping?
Global and Local shortcuts. Advantages.
What are the new features of informatica 9.x developer?