Handling dynamic templates of excel
Posted in the Informatica Forum
#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.
Add your comments below
|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|
Find what you want!
Search Informatica Forum Now
Copyright © 2016 Topix LLC