What is best approach to load 100 different source files
(Different structure) to differet target tables ?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the differences between joiner transformation and source qualifier transformation?
what is distinct
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What do you understand by SOA of Informatica?
how eliminate the duplicates in flat file with out using sorter ,aggregater
have you developed documents in your project? and what documents we develop in realtime?
what are types of dimentions?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is procedure to use mapping variable in source qualifier transformation? with example
How to eliminate duplicate records in informatica mapping? Explain with an example....
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?