source_>sq->expression->router->tg1

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.

Question Posted / triveni munnangi

7 Answers
14912 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

Please Help Members By Posting Answers For Below Questions

What is parallel processing in informatica?

1680

What are the various types of transformation?

1156

expain about the tune parameters?

2388

While migrating the data from one environment to another environment how would you manage the connections?

1073

What are the databases that informatica can connect to windows?

1034

Explain scd type 3 through mapping.

958

waht type of interface is used for testing the data in informatica

2237

What are the restrictions of union transformation?

1015

what is the -ve test case in your project.

2392

How does a sorter cache works?

1038

Tell me about Propagate functions in informatica

911

Explain the difference between mapping parameter and mapping variable?

1018

What is rank transformation?

968

difference between informatica 8.1.1 and 8.6

3659

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2047