Sppose in load directory i have 4 files which may be of different formate ,i have to pick all files to my job,Please advice me how to do this?
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Moderators: chulett, rschirm, roy
.chulett wrote:Normal answer would be the Folder stage, but first tell us how you propose to process multiple files with different metadata in a single job. That answer will help drive the proper solution. ...
yah it will give problem because in my job i will have to do header and trailer validation,which will not possible with single varchar column.Please advice me how to proceed.ray.wurlod wrote:If the files are of different format, how do you propose to process them all (parse them) in the same job? You are correct that you can read them using a single VarChar column, but what happens after ...