Hello Expertise,
I am trying to load the filenames from the folder to a table in ODI. and later loading the data from there to a single table.
I am able to load the data from 100 files from a folder. using loop concept ( used ODI Gurus: MULTIPLE FILES - SINGLE TARGET TABLE-SINGLE INTERFACE link to do that, but there I need to insert the filenames manually to one table. ) My Question is " Is there any procedure or jython script to load all the filenames to single table having with column FILENAME ".???
If there please help me in making that,
Thanks,
Santhosh