Handling dynamic templates of excel

Handling dynamic templates of excel

Posted in the Informatica Forum

Rajiv Gupta

Delhi, India

#1 May 19, 2009
We have excel files which is the source system. The number of files and the tabs in excel files are dynamic ie they can be added , add new excel files etc.

Now the client wants the ETL to be flexible enough to accomodate the addition of new tabs, read data from new excel files , new added tabs etc.

Also the data in new tabs may have different fields and different logic of handling.

How can we achieve the same dynamic nature in ETL so that it accomodate the new template and the corresponding data handling

Kindly update me.

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records (Feb '16) Feb '16 beginer_informatica 1
First and last rec from flat file to table (Feb '16) Feb '16 Nan 1
More from around the web