schema file

Satwika · Post by **Satwika** » Fri Jan 20, 2012 6:41 am

Hi ,

I have one job which is using schema file. And We have requirement to perform some transactions on the columns which were mentioned in schema file. This has to be done before loading into a target. Target also using the same schema file.

Job designed :

Seq file --> T/f --> Target .

In T/F i need to perform some transactions on some specified columns.
How to do this ?
Any suggestions in this. Thank you.

qt_ky · Post by **qt_ky** » Fri Jan 20, 2012 8:18 am

Need more info...

What kind of transactions?

What have you tried so far?

Are you getting wrong results or error messages?

Etc.

Satwika · Post by **Satwika** » Mon Jan 23, 2012 12:49 am

Hi,

Good morning

I have to do transactions on the 3 columns op_id , P_id and cus_opp_id. Aggregation functions i need to perform and i have to split the cus_opp_id based on the characters and processing only one part from the split. So, how to do this . All columns are performing from the schema file.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 23, 2012 1:26 am

No they're not. The schema file serves only to describe the record layout. You can perform Aggregations in the Aggregator stage (or some of them in a Transformer stage) but, to do so, you will need to name the output and input columns in that stage explicitly.