stage variable behavior

kjaouhari · Post by **kjaouhari** » Wed Oct 01, 2014 9:57 am

Hello guys,
In one of our jobs , I have different output for the same column. I am using a transformer stage for other reasons. If I propagate the column directly to the output I get the right result.
But If I propagate the input to a stage variable (witout any operation) and then pass the stage variable to the output I sometimes get a different result.

Any idea ?
Thanks

qt_ky · Post by **qt_ky** » Wed Oct 01, 2014 2:13 pm

I would guess it depends on the data type you selected, or did not select, as well as the nullable properties and what specific version of DataStage you are using.

Which version are you using?

Please give a specific example showing the different data values and elaborate on the data types involved in source, stage var, and target.

kjaouhari · Post by **kjaouhari** » Wed Oct 01, 2014 2:23 pm

I have 100 columns and 200 stage variables , If I just keep half of them then the problem disapear. Is there any limitation on the number of stage variables we can use in one job ?

qt_ky · Post by **qt_ky** » Wed Oct 01, 2014 2:35 pm

That doesn't sounds like too many, although there has to be a physical limit at some point.

Again, which version are you using?

Please give a specific example showing the different data values and elaborate on the data types involved in source, stage var, and target.

Have you opened a support case about this?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2014 4:24 pm

What, exactly, does "different result" mean?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2014 4:25 pm

There is no limit on the number of stage variables.

kjaouhari · Post by **kjaouhari** » Thu Oct 02, 2014 7:02 am

hehe , sorry guys I didn't see you already replied !

Here is an example :

Input Col --> Output Col
Input Col --> Stage Variable --> Output Col2
(no transformation in stage variable))

Code: Select all

Input Col               Output Col                  Output Col2
NULL                        NULL                        NULL  
NULL                        NULL                        NULL  
NULL                        NULL                        NULL 
NULL                        NULL                        3 
NULL                        NULL                        NULL 
NULL                        NULL                        NULL

Don't know where the '3' comes from.

Thanks.

kjaouhari · Post by **kjaouhari** » Thu Oct 02, 2014 8:04 am

The version we are using is 8.5 on unix. thanks

abc123 · Post by **abc123** » Fri Oct 17, 2014 1:54 am

What are the data types of Input Col, Output Col and Output Col2?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 17, 2014 4:43 pm

Or simply look in the RT_SCn directory in the project, without all those other steps.

rkashyap · Post by **rkashyap** » Tue Oct 21, 2014 10:13 am

One learns something new every day.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Oct 21, 2014 10:40 am

Only on good days!