Please let me know whether is there any limit on the no of records that can be loaded when the target stage is Teradata Enterprise stage and with the option Progress Interval : 1000000. This is the default value.
My source is having 60Lakh (6 Million) rows and job is finishing with 10L rows loaded and then finishing.
Job design is like this :
TD ENT > Transformer > TD ENT ( with null handling in T and nothing more in T )
Observed warning message is :
Teradata_Enterprise_11,0: Notification: APT_TERA_BYPASS_POST_LOAD_CHECKS is defined. Hence, post-load checks are disabled and the job proceeds assuming that all rows are loaded successfully
JOb is successfully finishing at 10L rows inserted into targettable.
Warnings :
Teradata_Enterprise_10: 39 sessions were requested, but only 38 will be created (2 per player for 19 players).
Teradata_Enterprise_10: ProgressCount is 0, progress counts have been disabled.
-----
Both source and target tables are multisettables with 2 columns declared as NUPI.
Target table is empty before loading. Please post replies.
Thanks
friend.kak@gmail.com
Teradata Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
Even though the target table is multiset the work table from which the data is select inserted into the target table is set table(This is a bug in stage). So my guess is that rest of the data is being dropped due to duplicate rows. Post the stats from the log file against this stage. it gives you the information pertaining to inserts,updates,deleted etc
Teradata Certified Master V2R5
-
- Participant
- Posts: 28
- Joined: Sat May 03, 2008 3:57 am
- Location: chennai
hamzaqk wrote:Even though the target table is multiset the work table from which the data is select inserted into the target table is set table(This is a bug in stage). So my guess is that rest of the data is being dropped due to duplicate rows. Post the stats from the log file against this stage. it gives you the information pertaining to inserts,updates,deleted etc
Yes, we came to know this. If the same requirement to be meet then can we use Teradata Multiload stage to perform the same. TPT connector is able to meet this.
Thanks,
friend.kak@gmail.com
- Dev