Hi,
I am using bulk mode in teradata connector stage for inserting Huge data into target tables. My question is , Does the bulk load behaves based on target table? i mean 1)if target table is empty, does the bulk mode assumes it as fastload ? 2) if target table have data in it does it assume as multiload? How exactly does the bulk load work.
Could some one please throw some light on this.
Thanks,
Aditya.
Teradata Connector bulkload
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Bulk load uses whatever you specify in the Load Type property when Access Method is set to "Bulk". This can be "Load" (Fastload), "Update" (Multiload) or "Stream" (TPump). The Teradata Connector stage can even use Fastload if the table is not empty.
For more information read the Connectivity Guide for Teradata Databases in your manuals set or the online help while editing the stage.
Make sure you have enough slots available if you're using Fastload.
For more information read the Connectivity Guide for Teradata Databases in your manuals set or the online help while editing the stage.
Make sure you have enough slots available if you're using Fastload.
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.
-
- Participant
- Posts: 32
- Joined: Tue Dec 13, 2011 7:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't know how it works. Some very clever engineers who wrote the Teradata Connector stage figured out how to get Fastload to append to a non-empty table. That much I learned at an IOD conference, but not the underlying mechanism.
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.
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
The Teradata connector does not utilize Fastload, it uses TPT (Teradata Parallel Transporter) for its bulk load. Fastload is a deprecated technology within Teradata and is not encouraged for use. A new Teradata install does not ship with Fastload, it would have to be requested and then would be discouraged.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: