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 is incremental aggregation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Clarify the utilization of aggregator cache record?
What is meant by query override?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to extract sap data using informatica?
how to create user defined function (udf) in informatica
Plz can any one say me how to get the informatica certification materials and dumps
Explain the mapping variable usage example in informatica
What is a transaction control transformation?
what is the complex transformation you used in informatica
Can you use flat files in Mapplets.
What does “tail –f” command do and what is its use as an Informatica admin.