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 do you migrate data from one environment to another?

869


How to Create a folder using pmrep command?

856


What is a standalone command task?

914


Write the different tools in the workflow manager?

802


Reusable transformation and shortcut differences

1603


How many ways a relational source definition can be updated and what are they?

808


What all join we can perform in LOOKUP transformation?

768


How to generate sequence numbers?

835


What are the designer tools for creating transformations?

904


hi real timers . iam waiting for ur reply regarding ETL TESTING

2055


Explain the aggregator transformation?

866


What are the steps involved in the migration from older version to newer version of Informatica Server?

1846


What is domain in terms of informatica?

786


Repository user profiles

1583


What is the session task and command task?

800