Page 1 of 1

How to change metadata datatype in Job using RCP

Posted: Mon Mar 18, 2013 7:19 pm
by G_rajeshk
Hi,

In my Job design I am using run time column propogation (RCP). The job design is simple...But it uses "Run Time Column Propogation"

Job design : DB2 Table ---> Transformer ----> Sequential File

I want to change the Data type will loading Data into File stage?

Is it possible with Runtime column propagation? Please suggest.

Thanks
Raj

Posted: Mon Mar 18, 2013 8:56 pm
by ray.wurlod
You cannot make any change without naming the column involved.

That does not preclude you from using RCP for other columns, of course.

If the data type change can be implicit, then a Copy stage is the simplest solution.

If you want a more generic design, make use of the fact that a specification in a Modify stage can be completely parameterised.

Or you can use an appropriate function applied to an explicitly-named column in a Transformer stage.