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

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,






What is workflow monitor?

0 Answers  


where is the reject loader .

1 Answers  


What is a mapplet/worklet in informatica?

0 Answers  


What is hash partition?

2 Answers  


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


What is dynamic cache?

0 Answers  


In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  


Categories