Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8397 Views
- TCS, I also Faced
- E-Mail Answers
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
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain pmcmd command usage in informatica
What are the features of complex mapping?
According to his methodology what all you need before you build a datawarehouse
Is there any way to read the ms excel datas directly into informatica?
What is a code page?
What is the way to execute pl/sql script using informatica mapping?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is an expression transformation in informatica?
Is stop and abort are same in informatica?
What is a predefined event?
What is the use of transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the surrogate key?
