0 - 2 of 2 tags for header
Check the Header of Flat file while Mload

Every day i will receive a Flat file which i have Mload it in prod. So i have to check the Header in file and make sure it matches with old one.
File Delimited '|'

Eg : S_NO | LNAME | FNAME  (Given header)

Eg : S_NO | LNAME | FNAME (File header)

By balu_td, 08 May 2013 | Tagged: unix mload header | 1 comment
BTEQ or Fast Load or Multi Load

Hi everyone! I am currently studying Teradata and currently working on this problem of mine. You see, i have this set of data on a flat file that needs to be loaded in a table based on a condition.

This is what my flat file looks like:

##Flatfile
SOR|03/17/2012|2 -- This is a header

By Waffuvan, 11 Mar 2012 | Tagged: teradata dml bteq update insert mload fast load delete row column file data staging table upsert header