We are Using Modify stage to add columns and also to add basic function like calculation in the derivation column but there is a binding error like syntax for the formulae ? So can we use the modify stage for that CAlculation.
pls highlight
Thanks
Yours
Sushanth
Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Probably not. As a general rule, transformations are performed in the Transformer stage (or in the BASIC Transformer stage).
Please describe exactly what you are trying to accomplish and where, and the exact error message generated and when (during compilation or at run time).
Please describe exactly what you are trying to accomplish and where, and the exact error message generated and when (during compilation or at run time).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
What are different functionalities of a modify Stage.
Hi,
When do we use a modify Stage anmd what are its features?
Apart from changing the data type droping or adding columns,
what else can we achieve through Modify Stage?
When do we use a modify Stage anmd what are its features?
Apart from changing the data type droping or adding columns,
what else can we achieve through Modify Stage?
Happy DataStaging
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
From the Parallel Job Developer's Guide:
The modify stage alters the record schema of its input data set. The modified data set is then output. You can drop or keep columns from the schema, or change the type of a column. (Emphasis mine.)
The modify stage alters the record schema of its input data set. The modified data set is then output. You can drop or keep columns from the schema, or change the type of a column. (Emphasis mine.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
According to Datastage Best Practices, Modify stage is the most effecient stage when compared to other PX stages. Modify stage is best used for explicit type conversion and null handling. If you want to do Implicit type conversion use the copy stage. But if you want more fuctionality other than these then you make use of the Transformer stage.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
According to Datastage Best Practices, Modify stage is the most effecient stage when compared to other PX stages. Modify stage is best used for explicit type conversion and null handling. If you want to do Implicit type conversion use the copy stage. But if you want more fuctionality other than these then you make use of the Transformer stage.
HTH
--Rich
Pride comes before a fall
Humility comes before honour
Modify Stage
To only add new columns Column Generator is suitable.
But to add new column with derivation Transformer stage is suitable.
Using modifgy stage we can drop or Keep columns,Type_Conversions and Null Handlings.
Ex:to handle nulls:
col1=Handle_Null(col1,0)
Regards
Beeram
But to add new column with derivation Transformer stage is suitable.
Using modifgy stage we can drop or Keep columns,Type_Conversions and Null Handlings.
Ex:to handle nulls:
col1=Handle_Null(col1,0)
Regards
Beeram