What is best approach to load 100 different source files
(Different structure) to differet target tables ?

Answer Posted / mahesh manam

For different source and different target you can make all
the mappings in ONE mapping.
And create a session for that mapping and you can call it.
If you have any constraints to load from particular target
and than some other target like wise any priority than
mention target load in mapping level
(Mappings --> target load plan --> give your priority)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you increase the performance in joiner transformation?

938


What is the use of target designer?

805


which one is better performance wise joiner or look up

847


What is workflow monitor?

796


What is transformation?

881


What do mean by local and global repository?

929


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

1868


What is a repository? And how to add it in an informatica client?

907


Repository user profiles

1571


How to update or delete the rows in a target, which do not have key fields?

901


What is the different lookup cache(s)?

813


What is the session task and command task?

786


Differences between version 7.x and 8.x.

1640


What are data-driven sessions?

949


Is it possible to create multiple domains on a single Informatica server?

1010