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 different lookup cache(s)?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
how to create a sample mapping for dynamic lookup transformation
How the facts will be loaded? explain
How to update source definition?
guys which is the best institute in banglore to learn informatica??
my source is junk data how will u remove that junk data by using unix please any one replay me
How many dimensions are there in informatica?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
what is shared Cache. when we will use shared Cache?