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.
- 7 Answers
- 13786 Views
- TCS, I also Faced
- E-Mail Answers
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
have u done any performance tuning? how u ll do?
What is the difference between a repository server and a powerhouse?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are mapplets? How is it different from a Reusable Transformation?
What are roles and groups and benefits of using them?
What is mapping debugger?
can u give example for factless fact table
Explain the different dimensions.
What is an Integration service in Informatica?
What is rank index in rank transformation?
What is a connected transformation?
What does role playing dimension mean?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the static cache and dynamic cache in informatica?
Different sorts of metadata that stores in the storage facility?
