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
Explain what are the different types of transformation available in informatica.
How to update a particular record in target with out running whole workflow?
tell me the rules and responsblites in our project(my project is development)
can u give example for factless fact table
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.
Write the different tools in the workflow manager?
Is there any way to read the ms excel datas directly into informatica?
What is the use of code page?
How you can differentiate between connected lookup and unconnected lookup?
wf dont have integration severances how you can run?
In which transformation you cannot drag ports into it?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the different lookup cache(s)?
What are the tasks that can be performed using sq?
What is standalone command task?