What is best approach to load 100 different source files
(Different structure) to differet target tables ?
- 2 Answers
- 10280 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 Business Components in Informatica?
What are the connected or unconnected transforamations?
How an expression transformation differs from aggregator transformation?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Under which circumstances, informatica server creates reject files?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
In development project what is the process to follow for an etl developer from day1
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the Process to creating lookup transformation in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Why do we need informatica?
Teradata 
