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 |
If u r using dynamic cache lookup port will be thier in thet which option u will select
What is Cognos script editor?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Can yoU use the maping parameters or variables created in one maping into another maping?
What are the parts of Informatica Server?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
How to load duplicate records in to a target table which has a primary key?
What are the various types of transformation?
What are the options in the target session of update strategy transsformatioin?
What is DTM process?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is the use of target designer?