DSXchange

Posted: **Tue May 20, 2014 10:06 pm**

Hi,

I have few jobs which use Teradata API stage with User Defined SQL method in Insert write mode.
I am loading my target table by selecting records from source table and applying few joins/formatting.
My job gets completed successfully but in Director log, the number of records inserted/updated/deleted shows as 0 but in actual some records have actually gone into target table.
This is happening for only few jobs. Does anyone has faced such situation? Requesting your inputs

Posted: **Wed May 21, 2014 12:30 am**

Two questions.

1. Do other links in your job show a non-zero row count?

2. What is the stage type upstream of the Teradata API stage?

Posted: **Wed May 21, 2014 4:07 am**

My job design is as follows:-

Code: Select all

rowgen -> teradata api stage

Here rowgen stage is acting as a dummy stage which sends just 1 record which is not used anywhere.
All the data processing takes place via a SQL which is written in API stage.
Something like

Code: Select all

Insert Into tab1
(col1,col2,col3....)
Select col1, col2, col3....
From tab2

I know using a DS job here does not solve any purpose but this is the way jobs have been developed before, so had to stick with it.

Also, it is not happening for all the jobs of similar type (rowgen -> tera API), only for few. I tried finding any property difference but of no use.

Posted: **Wed May 21, 2014 6:38 am**

Add a reject link.

DSXchange

Director log not showing correct number of records inserted

Director log not showing correct number of records inserted