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

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


What is IQD file?

1 Answers  


which one is better performance wise joiner or look up

0 Answers   Informatica,


every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,


HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,






what is the incremental agrrigation?

2 Answers   Cap Gemini,


can we use bulk loading when we use look in mapping

1 Answers   TCS,


how to delete duplicate records by using filter transfermation?

3 Answers  


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,


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

0 Answers  


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


Categories