How to flag each flat file record with the filename?

sagar deshmukh · Post by **sagar deshmukh** » Fri Jul 16, 2010 5:09 am

Hi,

I need a help regarding a requirement... I need to design a job where I have Three files which will arrive in a folder..I need to create a simple job which will read all the three files one by One...and load datainto final table...but each column should be flaged with the file name from which it has fetched... Ex. Say 1st record came from File called "A" then it should be flaged as" A" in one of the flag column....

How can i achieve this....as my all three files can arrive at same time or may be at different time also

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 16, 2010 5:37 am

Use a job sequence to obtain list of files from the folder and call your load job with the file name as a parameter.

Give it a try and post if you have any issues.

chulett · Post by **chulett** » Fri Jul 16, 2010 6:04 am

The Sequential File stage supports a 'Filename' column it can add for you. Do you need to wait for all three before you process? How are you planning on doing that?

ray.wurlod · Post by **ray.wurlod** » Fri Jul 16, 2010 2:33 pm

Please try to choose meaningful subject.

chulett · Post by **chulett** » Fri Jul 16, 2010 9:23 pm

Yes - we know you "Need Help", that's why people start posts here. Let me see if I can help... [scratches head] hmmm...