Buildop design

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
AnushaReddy
Participant
Posts: 13
Joined: Thu Dec 02, 2010 2:55 am

Buildop design

Post by AnushaReddy »

Hi ,

Requirement :

Based on the first column data(Record Type) need to pass the values to the concerned columns in the table and rest need to be null.

Many columns are there so not able to define using Transformer stage.

Can anyone help how to build a Buildop.


Thanks,
Anu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Why would 'many columns' stop you from using a Transformer? It may be a little bit of drudgery to set up but it's not like it won't work. Out of curiosity, how many record types do you have?

You do understand a Build Op requires you code it in C++, yes? Do you have that skill in-house?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply