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

What is meant by query override?

629


how to create user defined function (udf) in informatica

776


What are the informatica performance improvement tips

605


What is the scenario which compels informatica server to reject files?

595


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1960






Differentiate between a repository server and a powerhouse?

565


What are the mapping parameters and mapping variables?

614


How to do unit testing in informatica?

712


Explain informatica architecture - version 8 / 9

657


Explain about cumulative Sum or moving sum?

614


Define Pmrep command?

625


What is the cumulative sum and moving sum?

743


Briefly define a session task?

584


How to load a Dimension ? and how to load a fact table?

944


what is diff b/t sorter t/r and agg have the option sorter property...

1730