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
- 7017 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 native users?
In development project what is the process to follow for an etl developer from day1
What is transformation?
How can we use mapping variables in informatica? Where do we use them?
Can we override a native sql query within informatica?
How can informatica be used for an organization?
In informatics server which files are created during the session rums?
Write the prerequisite tasks to achieve the session partition?
Explain the pipeline partition with real time example?
write a query to retrieve the latest records from the table sorted by version(scd)
how to load rows into fact table in data warehouse
What are the limitations of joiner transformation?
How do you load alternate records into different tables through mapping flow?
What are active and passive transformations?
State the differences between sql override and lookup override?
