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 / 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 the command used to run a batch?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
COM components can be used in Informatica
How to do the error handling of if ur source is flatfiles?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is an active transformation?
What are different types of transformations available in informatica?
How are the sources and targets definitions imported in informatica designer?
What is joiner change?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is different between the data warehouse and data mart?
what is INFORMATICA TESTING process
Enlist the advantages of informatica.