When you will use Append mode to insert data into the final table, Enterprise stage create a working table, all the rows are written into that table thats what the log is saying Rows written: 153,027,180. After this step the data is copied to target table using the following query
INSERT INTO TARGETTABLE
SELECT * FROM WORKTABLE
so according to the log there are 4 rows which are already present in the target table so they are dropped, and thats why Input rows: 153,027,176
Observation in Teradata Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)