Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is best approach to load 100 different source files
(Different structure) to differet target tables ?

Answers were Sorted based on User's Feedback



What is best approach to load 100 different source files (Different structure) to differet target t..

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

What is best approach to load 100 different source files (Different structure) to differet target t..

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

Post New Answer

More Informatica Interview Questions

What are the different lookup cache(s)?

0 Answers  


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

1 Answers  


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

4 Answers   IBM,


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


how to create a sample mapping for dynamic lookup transformation

2 Answers  


How the facts will be loaded? explain

2 Answers   HCL,


How to update source definition?

0 Answers  


guys which is the best institute in banglore to learn informatica??

2 Answers  


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


How many dimensions are there in informatica?

0 Answers  


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?

1 Answers   Franklin Templeton,


what is shared Cache. when we will use shared Cache?

4 Answers  


Categories