Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15227 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
what is size of u r database?
What are the tasks that source qualifier perform?
What are the types of presistent cache in look up tr.
What is an unconnected transformation?
What are the different lookup cache(s)?
What are the different types of transformation available in informatica.
How can we use mapping variables in informatica?
What all are steps in up gradation of Informatica server?
What is rank index in rank transformation?
How can you define user defied event?
Explain the use of aggregator cache file?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Different circumstance which drives informatica server to expel records?
Explain sessions and how many types of sessions are there?
