Server v/s EE
Posted: Thu Sep 27, 2007 8:28 am
I am migrating Server jobs to EE jobs and I am noticing that in EE jobs one has to take care of null values or else we get warnings. Example
COL NAME = COL_DT
TYPE = CHAR
LENGTH = 10
NULLABLE = Yes
This is the only difference between the Server and Parallel job. But the counts of rows loaded by both the jobs differ by 3. Parallel has 3 more rows loaded then the server job.
I have seen that the parameters for date passed both in server and Parallel are the same rest all is the same. There are no constraints or variables or any other things used.
Would appreciate if somebody could explain the difference, or what I am missing.
COL NAME = COL_DT
TYPE = CHAR
LENGTH = 10
NULLABLE = Yes
Code: Select all
In the server job this is what is done in Transformer
COL_DT[1,10]
EE Transformer
If IsNull(COL_DT) then SetNull() Else COL_DT[1,10]
I have seen that the parameters for date passed both in server and Parallel are the same rest all is the same. There are no constraints or variables or any other things used.
Would appreciate if somebody could explain the difference, or what I am missing.