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
What is the difference between Active and Passive transformation?
difference between informatica 8.1.1 and 8.6
Explain the different dimensions.
What are the limitations of joiner transformation?
What are the reusable transformations?
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.
Have you worked with/created Parameter file
What is a joiner transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain lookup transformation source types in informatica
Why union transformation is an active transformation?
What is DR strategy for Informatica project?
What is union transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are connected or unconnected transformations?