DSXchange

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...

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....

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.

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?

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.