Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table and 3 target table.
when session runs first time-1st tgt
second time-2nd tgt
third time-3rd tgt
fourth time-again 1st target. so no
- 4 Answers
- 6869 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
Take a mapping variable of count type $$INCR=1
After SQ take expression and add a variable port
v_INCR_VARIABLE= IIF($$INCR=3,SETVARIABLE($$INCR,0)+1)
Take router and add three groups
Group1-> $$INCR=1
Group2-> $$INCR=2
Group3-> $$INCR=3
Add groups to respective targets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the function of union transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How can we remove the duplicates from flat file source?
Which transformation is needed while using the Cobol sources as source definitions?
What are the types of caches in lookup? Explain them.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is data transformation manager process?
What is the meaning of up gradation of repository?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In which transformation you cannot drag ports into it?
What is a joiner transformation?
What is workflow manager?
Why do you use Mapping Parameter and mapping variable?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
