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
How would you copy the content of one repository to another repository?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the meaning of up gradation of repository?
What is the use of source qualifier?
What are some examples of informatica etl programs?
How do you promote a non-reusable transformation to reusable transformation?
How to go to the older version for a mapping?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a snowflake schema?
Define the various join types of joiner transformation?
What are active transformations.
differences between service based and product based?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Enlist few areas or real-time situations where informatica is required.
What is the session task and command task?