Warnings for Null Values

[shwetha.st]

Hi All

My requirement is that i have to see warnings for the null values also.
My source is a csv file with 5 columns only and target is relational table.
Taret is something like EMPID,ENAME,LEVEL1,LEVEL2,LEVEL3.
EMPID is a primary key.
My scenario is if the level1,level2,level3 are null there must be a warning message in the director as these columns are null inspite of job being succesful and all othe columns are loaded,which i am not able to see now.
Could any one please help me out in this....


Thanks

[ray.wurlod]

Derive a stage variable as

Code: Select all

If IsNull(InLink.Level1) Or IsNull(InLink.Level2) Or IsNull(InLink.Level3) Then UtilityWarningToLog("Level field is null") Else 0

. You don't have to use the stage variable.

[sachin1]

my doubt is in database are these columns ,LEVEL1,LEVEL2,LEVEL3. null or not null, if it is not null then you can use "Treat Warning as error message checkbox", but then your job will not run.

if they are null we can find some solution for your implementation.

[sachin1]

sorry regarding improper relply, yes the sdk routine UtilityWarningToLog is what you wanted