I have a file which will have list of files that i need to read. All this files will be in same directory and but non similar names.
How could i make this read these files using sequential file stage or any other stage.
The number of files will vary each time.Say My main file is: Filelist.txt. It contains following data
input1.txt
hours2.txt
customer3.txt
I like to read content of all these files and perform transformations and load it into target table.
I could do this using external source stage.
I am looking all other options i have and the easiest and optimum on performance.
Note: These files are huge around 10+ million each file.
Help is appreciated.