Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
Answer Posted / triveni munnangi
source_>sq->expression->router->tg1
->tg2
expression:v_count decimal 10 0(variableport) setvariable($$cnt,1)
o_count decimal 10 0 (outputport) $$cnt
router:groups
t1=o_count=0
0_count=1
$$cnt variable integer 10 0 max false
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
wf dont have integration severances how you can run?
Which development components of informatica have the highest usage?
What is exclusive and normal mode for repository services?
Explain the pipeline partition with real time example?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What all join we can perform in LOOKUP transformation?
tell me about your project functionality
What is meant by active and passive transformation?
what is index?how it can work in informatica
Is there any way to read the ms excel datas directly into informatica?
What is dimensional table?
According to his methodology what all you need before you build a datawarehouse
What are the types of data warehouses?
What is meant by lookup transformation? Explain the types of lookup transformation?