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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle decimal places while importing a flatfile into informatica?

710


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1677


What are the types of schemas we have in data warehouse and what are the difference between them?

512


Explain where to store informatica rejected data? How to extract the informatica rejected data?

567


What are the advantages of informatica?

562






What is the need of an ETL tool?

631


Describe expression transformation?

624


Explain the features of connected and unconnected lookup.

529


In warehouses how many schemas are there?

572


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1607


Did u used latest transformations of 8.6.0? for what?

1469


what are 3 tech challenges/ common issues you face?

1875


How does the aggregator transformation handle null values?

689


What are the different lookup cache(s)?

610


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

700