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
- 8263 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
How to load the data from a flat file into the target where the source flat file name changes daily?
Enlist few areas or real-time situations where informatica is required.
What is informatica etl tool?
What is powercenter on grid?
How do you convert single row from source into three rows into target?
How to open an older version of an object in the workspace?
What is the command used to run a batch?
What is a grid in Informatica?
Where is metadata stored?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain lookup transformation is active in informatica
Informatica Checkpoints
What are active transformations.
Explain what transformation and how many are there in informatica?
How do you handle two sessions in Informatica
