My source dataset has 60097 records as input to Teradata multiload stage. But what I get for inserts is only 60096 records on the table.
There is no duplicates kick out on UV report and no rows on ET report.
I'm using keys on AR_ID, DW_SRVC_ID and CAPTR_DT and there are no duplicates on combination of these keys. The table has no primary key but only primary index (AR_ID).
Can anyone know of any reasons why 1 record gets dropped from doing inserts to the table?
Teradata multiload 1 record gets dropped
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Unlikely to be "first line is column names" from a Data Set.
What is your job design? Please use "ASCII art" within Code tags - it makes it so much easier to read.
What row counts are reported on each link?
Enable APT_RECORD_COUNTS (perhaps as a job parameter) so that the player processes log their row counts.
Is there some reason you're preferring the MultiLoad stage to the Teradata Enterprise stage? Are you specifying a Report file on the MultiLoad/TPump tab?
What is your job design? Please use "ASCII art" within Code tags - it makes it so much easier to read.
What row counts are reported on each link?
Enable APT_RECORD_COUNTS (perhaps as a job parameter) so that the player processes log their row counts.
Is there some reason you're preferring the MultiLoad stage to the Teradata Enterprise stage? Are you specifying a Report file on the MultiLoad/TPump tab?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.