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
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you migrate data from one environment to another?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is INFORMATICA TESTING process
Can we override a native sql query within informatica?
What is the need of etl tools?
Why sorter is an active transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Differentiate between router and filter transformation?
What is data transformation manager process?
How many transformations can be used in mapplets.
What is primary and backup node?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is option by which we can run all the sessions in a batch simultaneously?