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
- 8212 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 update source definition?
How can we delete duplicate rows from flat files?
What is the use of transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What is Data Caches size?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How might you approve all mappings in the archive all the while?
How do you change a non-reusable transformation to reusable transformation?
According to his methodology what all you need before you build a datawarehouse
Differentiate between router and filter transformation?
How many ways a relational source definition can be updated and what are they?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
tell me the rules and responsblites in our project(my project is development)
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain the types of transformations?
