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
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
Differences between version 7.x and 8.x.
What is meant by lookup transformation? Explain the types of lookup transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the types of lookup transformation?
Under what condition selecting sorted input in aggregator may fail the session?
Is stop and abort are same in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How can a transformation be made reusable?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to update a particular record in target with out running whole workflow?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how many types of dimensions are available in informatica?
Define Pmrep command?
What do you mean by enterprise data warehousing?
Mention some types of transformation?