Handling nulls in Stage Variables In Transformer

[ds_raman]

Hi
There are null values coming in from source and i need to set a flag for this field(Empid), but when i try to check if Empid is null in Stage variable, the records get dropped, and the same applies for date of birth field, DOB,
Is there anyother way in Transformer by making use of Stage Variables i can set the Flag to "N" for Null Values

[Maveric]

Check the nullability of your target fields. Post the derivations here. Are you trying to substitute N for a NULL, or are you just checking for null and populating the Flag field to N?

[ds_raman]

Check the nullability of your target fields. Post the derivations here. Are you trying to substitute N for a NULL, or are you just checking for null and populating the Flag field to N?

I am trying to substitue "N" for nulls

[balajisr]

Can you post your derviation?

[Maveric]

What is the Data type of your input and output fields? And Why use stage variables? A simple derivation like

Code: Select all

 If IsNull(In.EmpID) Then "N" Else In.EmpID 

would do. This will work only if the data type is char or Varchar. Only then would you be able to substitute the value N.

[ds_raman]

Can you post your derviation?

Stage Variable i am using Null_F=NullToValue(EmpIdExist,'N')

And on the Constraint if Null_F='N' then the records are routed to Error Link

[ds_raman]

What is the Data type of your input and output fields? And Why use stage variables? A simple derivation like

Code: Select all

 If IsNull(In.EmpID) Then "N" Else In.EmpID 

would do. This will work only if the data type is char or Varchar. Only then would you be able to substitute the value N.

Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables, Kindly suggest how i can solve this using StageVariables, and route the records based on the value contained in StageVarialble (Null_F)

[chulett]

Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

[ds_raman]

Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

Solved the problem.,
Thank You,

[ds_raman]

Thanks but i need to route the recors to Error Link, so i have to make use of StageVariables

No, you don't have to use stage variables. You can use your null check directly in the constraint that 'routes' the records.

Solved the problem.,
Thank You,

[chulett]

Time to mark the post as Resolved, then.