Sequencial Steps Problem

[vickycavazos]

I have a doubt about how job's are working...
I have a job that does the next:
ODBC Informix as DataSource --> Transformation --> ODBC Redbrick DataDestination
Just one integer column which values are 1,2 and 3 only...
I can see that log registrates every row...in the log after the execution is finished, this happens:
step 1: 1 row insert
value = 1
step 2: 0 row insert, step fail
value = 1
step 3: 1 row insert
value = 2
step 4: 0 row insert, step fail
value = 2
step 5: 1 row insert
value = 3
step 6: 0 row insert, step fail
value = 3
WHY EXECUTE TWICE THE ROW INSERTION, AND WHY THE FIRST TIME WORKS AND THERE IS A SECOND TIME THAT FAILED??

I'm frustrated because it's a simple job and it doesn't work normally and i don't know why!!

Really thanks for your help..

Vicky Cavazos

 

[JGirl]

Hi,

Im not sure that I fully understand what the problem you are having is. If you only have one integer column (and no other columns - is this what you mean?), the second row insertion will fail because you cant have duplicate rows in a table.

Also - have you checked your input data (from informix odbc stage) to see that the input data is in the form you are expecting (using the 'View Data' option)?

The log you are talking about - is this the datastage job run log, or the redbrick load.log file?

J