Alternative to mapping variable: Use sequence generator, mod on that and

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 / subhajit

7 Answers
15242 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / subhajit

Alternative to mapping variable:

Use sequence generator, mod on that and then finally router.

Thanks

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can u generate reports in Informatica?

1143

What is domain and gateway node?

1205

What is pmcmd command?

1179

What are the different lookup cache(s)?

1166

permutations of mapplet

2548

What are the differences between oltp and olap?

1017

What is the reusable transformation?

1100

What can we do to improve the performance of informatica aggregator transformation?

1141

What is meant by LDAP users?

1286

What are session parameters ? How do you set them?

1899

What are the types of caches in lookup?

1094

How to join three sources using joiner? Explain though mapping flow.

1189

What all join we can perform in LOOKUP transformation?

1019

What do mean by local and global repository?

1278

How to open an older version of an object in the workspace?

1264