Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to make selection of null values and check the data variation. So how should i do it in the script for the particular field?
Hi Priyanka,
You can use
If(IsNull(Field),'Null Value',Field) AS Field
Or
NullAsValue Field;
Set NullValue = 'Null Value';
// Make your final load here
Load
...
;
NullAsNull Field;
More performant than the If