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
- 7087 Views
- HCL, I also Faced
- E-Mail Answers
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 unit testing?tell me proceedure
What are mapplets?
Differentiate between Load Manager and DTM?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between informatics 7x and 8x and what is latest version?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What does refresh system mean, and what are its distinctive choice?
Explain sessions and how many types of sessions are there?
How do you use reject loader.
Is it possible to revert a global repository to local one and why?
What do mean by local and global repository?
Implementation methodology
What is the advantage of informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
