Search found 5 matches

by josfar
Wed Oct 31, 2007 2:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where is the Reject Data of Teradata Enterprise Stage?
Replies: 12
Views: 8921

nishadkapadia wrote:Duplicate rows will never be captured in any database table.
Since teradata enterprise stage uses native teradata fastload utility which
has this feature.
At the most, field Conversion errors and Duplicate Index errors will be captured in the error tables which is zero as per your log.
Thank u! :)
by josfar
Mon Oct 15, 2007 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where is the Reject Data of Teradata Enterprise Stage?
Replies: 12
Views: 8921

Database table ! Names of the tables are ERR_cookie_1 and ERR_cookie_2. Cookie can be found on the terasync table. In that table, you may use start time and end time (integer) fields in order to find the last ones inserted and you cannot modify these error table names. This should lead you to formu...
by josfar
Mon Oct 15, 2007 3:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where is the Reject Data of Teradata Enterprise Stage?
Replies: 12
Views: 8921

Database table ! Names of the tables are ERR_cookie_1 and ERR_cookie_2. Cookie can be found on the terasync table. In that table, you may use start time and end time (integer) fields in order to find the last ones inserted and you cannot modify these error table names. This should lead you to formu...
by josfar
Mon Oct 15, 2007 1:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where is the Reject Data of Teradata Enterprise Stage?
Replies: 12
Views: 8921

Where is the Reject Data of Teradata Enterprise Stage?

While using Teradata Enterprise Stage for loading data into Teradata DB, whether there are rows rejected or not , the job can finished ok. But in our situation, even only one row data is rejected, we should get it and generate a Zero-size file to tell others ," the job is finished with rejected...
by josfar
Wed Jul 11, 2007 1:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error: APT_TeraSync: could not create operator sync table
Replies: 5
Views: 3792

This has been marked Resolved - could you post your resolution? Someone with similar issues may find the solution of value :) Brad. i ran with the same problem. And here is the solution: 1. if ur Read Method is set to "Table", and had specified the "Database" in Connection Categ...