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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Can we create two repositories on same database instance in oracle?
How many ways a relational source definition can be updated and what are they?
What is the command used to run a batch?
How can repository reports be accessed without sql or other transformations?
can anyone suggest best free Talend data integration training online
differences between service based and product based?
What is the scenario which compels informatica server to reject files?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are multi-group transformations?
Explain the informatica workflow?
What is informatica worklet?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are ETL Tools?
Can we create a node as a gateway node and the same node can be assigned to a grid?