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
Director log not showing correct number of records inserted
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Tue Jan 19, 2010 4:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 50
- Joined: Tue Jan 19, 2010 4:14 am
My job design is as follows:-
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
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.
Code: Select all
rowgen -> teradata api stage
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
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.