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

Answers were Sorted based on User's Feedback



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

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

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

Answer / manojkumar challagundla

Yes you are correct.

Am just checking here like is there any better approach.

Thank you

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


What is difference macros and prompts?

2 Answers  


What are multi-group transformations?

0 Answers   Informatica,


What are the reusable transforamtions?

2 Answers  


what is INFORMATICA TESTING process

0 Answers  






If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


wf dont have integration severances how you can run?

0 Answers   TCS,


When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,


What are the prerequisite tasks to achieve the session partition?

0 Answers  


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,


Categories