Schema file

Kumar.Puttaswamygowda · Thu Jan 17, 2008 4:24 am

My Job:
Seq_File---->Transformer--------->Seq_File

I'm using Schema file to define table definiton in the source. Assume we have columns A,B,C... in source. If i want to read any one column explicitly in Transformer, how can i do that? Pls help me...

us1aslam1us · Post by **us1aslam1us** » Thu Jan 17, 2008 4:28 am

If you mean to drop the other two columns then simply delete those columns from the transformer output tab or even better method will be to use modify stage to drop the columns. I hope you are not asking this....

ray.wurlod · Post by **ray.wurlod** » Thu Jan 17, 2008 5:42 am

Anything you want to do with an input column in the Transformer (or Modify) stage you need explicitly to name that column in the stage input link.

Kumar.Puttaswamygowda · Thu Jan 17, 2008 10:58 pm

Hi Ray/us1aslam1us,
Thanks for quick reply.

us1aslam1us,
I'm not trying to drop any column, infact i'm trying do some transformation with input columns.

Ray,
Your view is correct, but if i use Schema file then i dont have option to explicitly name the columns in stage input link, becuause schema file will override the column and format tab. I think u r getting my point?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 18, 2008 5:39 am

Tough.

Anything you want to do with an input column in the Transformer (or Modify) stage you need explicitly to name that column in the stage input link.