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
- 7018 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kuni_ankita
Take one variable $$var
in exp trans take one variable port and assign set variable($$var,$$var+1)
then take one router transformation with three group
mod($$var,3)=1 to one tgt
mod($$var,3)=2 to next tgt
mod($$var,3)=0 to another tgt
SD-SQ-EXP-ROUTER-TD1 TD2 TD3
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Parameter and variable differences
How might you approve all mappings in the archive all the while?
How to Create a folder using pmrep command?
How will the document be delivered to me?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the new features of informatica 9.x at the developer level?
What are the differences between a connected lookup and unconnected lookup?
In development project what is the process to follow for an etl developer from day1
What is the difference between a connected look up and unconnected lookup?
Can we create a node as a gateway node and the same node can be assigned to a grid?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Why update strategy and union transformations are active?
Explain joiner transformation in informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
