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
- 8275 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / santosh
1. Create a mapping variable $$SESSION.
2. Link from SQ to Router t/r.
3. Create two group
a. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 1
b. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 0
4. Link both group to two filter and create two Sequence geneter and check the reset option.
5. Link the sequence generator to filter t/r.
6. Keep the condition as "NEXTVAL<=10" for first filter.
7. Keep the condition as "NEXTVAL>10" for second filter.
8. Link the two filter to two different target instance.
Let me know if any things wrong.
Thanks & Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
What is a transaction control transformation?
Explain lookup transformation in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How does a rank transform differ from aggregator transform functions max and min?
What are the restrictions of union transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is workflow monitor?
Where can we find the throughput option in informatica?
Explain what are the different versions of informatica?
How can repository reports be accessed without sql or other transformations?
What is domain and gateway node?
