Checking unique values in all records.
Posted: Fri May 30, 2008 8:15 am
Hi Dsxians,
I have a requirement to check the date column value is same for all the records
from source file using transformer stage in the extract job.
For eg:
run_date
01/23/2008
01/23/2008
01/23/2008
01/23/2008
01/23/2008
If it is not same for all the records,I want to stop the process.
I tried writing the changed values to a temp file using the below condition and check the file size at sequence
level and if there is changed value(ie temp file size greater than zero) i am controlling the process by writing a
message to log Utilitymesssgetolog(" SDSD").
Condition is
Stage variables-
svCurr --> run_date
svUni -->If svPrev <> svCurr Then '1' Else '0'
svPrev --> run_date
Constraint-->Svuni =1
But in this condition,even if all the date values are same the first two values are writing to the file.
01/23/2008
01/23/2008
Could you please help me to acheive this.Thanks.
I have a requirement to check the date column value is same for all the records
from source file using transformer stage in the extract job.
For eg:
run_date
01/23/2008
01/23/2008
01/23/2008
01/23/2008
01/23/2008
If it is not same for all the records,I want to stop the process.
I tried writing the changed values to a temp file using the below condition and check the file size at sequence
level and if there is changed value(ie temp file size greater than zero) i am controlling the process by writing a
message to log Utilitymesssgetolog(" SDSD").
Condition is
Stage variables-
svCurr --> run_date
svUni -->If svPrev <> svCurr Then '1' Else '0'
svPrev --> run_date
Constraint-->Svuni =1
But in this condition,even if all the date values are same the first two values are writing to the file.
01/23/2008
01/23/2008
Could you please help me to acheive this.Thanks.