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 rank index in rank transformation?
Reusable transformation and shortcut differences
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what is SDLC way of code development?
How to improve the performance of a session using sorter transformation?
Clarify the aggregator change?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what is the size of u r source(like file or table)?
Differences between version 7.x and 8.x.
What do you mean by enterprise data warehousing?
What does cheating measurement mean?
What are the databases that informatica can connect to windows?
permutations of mapplet
Describe expression transformation?
What is union transformation in informatica?