How to get the Metadata information in derivation?

Sachin K.C. · Post by **Sachin K.C.** » Fri Nov 24, 2006 4:17 am

Hi,

I want to validate the sequential file column heading & their position in the file. i.e. column heading should come in particular order.

field01='Column A'
field02='Column B'
field03='Column C'
field04='Column D'
....
...
..
How i will check the metadata in transformation processing constraint ?

Guide me and validate for same.

Thank's

Nageshsunkoji · Post by **Nageshsunkoji** » Fri Nov 24, 2006 5:39 am

Hi,

you can acheive the same thing by using Unix script or unix funations. Call the same in the After Job subroutine of the job.

Checking the header and position of the column is quite possible with the shell script.

kduke · Post by **kduke** » Fri Nov 24, 2006 3:16 pm

There is a routine on my tips page which will validate the metadata. Download it.