Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

Which are the different editions of informatica powercenter that are available?

790

What is native users?

902

How do you convert single row from source into three rows into target?

863

Global and Local shortcuts. Advantages.

1670

What are the components of Informatica? And what is the purpose of each?

810

What are the types of presistent cache in look up tr.

1803

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1864

What are the static cache and dynamic cache in informatica?

950

How do you load unique records into one target table and duplicate records into a different target table?

945

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1275

What is the function of union transformation?

832

Could you explain what is enterprise data warehouse?

747

How might one distinguish in the case of mapping is right or not without associating session?

839

What are the new features of informatica 9.x developer?

731

What is data caches/ index caches?

798