DSjob Using Teradata Fastload
Moderators: chulett, rschirm, roy
DSjob Using Teradata Fastload
Hi Guys,
How to create a job to load the data in a pre-populated Teradata table using Fast Load. Please give me guideliness for doing this job.As i am new to teradata with datastage.
Thanks in advance to helping out.
How to create a job to load the data in a pre-populated Teradata table using Fast Load. Please give me guideliness for doing this job.As i am new to teradata with datastage.
Thanks in advance to helping out.
Last edited by swathik on Mon Apr 14, 2008 3:02 am, edited 2 times in total.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What you say is true, but DataStage hides that from the developer by describing the operation as "Fast Load in Append Mode".hamzaqk wrote:You cannot fastload into an already populated table. it Multi loads data into the table. this is one of the reasons that a temporary table is created when we use the enterprise stage.
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.
Thanks, but i do not support the idea that it should be called "Fast load in append mode" in the first place as the name conflicts with the real functionality of fastload itself. Apart from this the only fast load which the job does while using Enterprise Edition is into the empty table work_orch_xxx from which it simply does and select-insert opertation. (of record another very fast way of loading data in TD provided PI is the same for temp table and target table). :D
one (possibly useless) remark on using enterprise stage for TeraData - we found that it seems to do a count(*) before and after the actual load (which as already mentioned does a fastload into a staging table - then insert from subselect).
If there are more than 2Billion records in the target table then the count causes an aritmetic overflow which generates an error (though doesnt abort as I recall) - u cant switch this off - but can cause be confusing
If there are more than 2Billion records in the target table then the count causes an aritmetic overflow which generates an error (though doesnt abort as I recall) - u cant switch this off - but can cause be confusing
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
I think the confusion here is around semantcis of the words "Fast Load" ; In the Teradata world, Fast load is the name of their utility that loads only to a non-empty table. When IBM developed the Teradata Enterprise stage, they worked with Teradata to make a fast load that can append to a table. So the DS Enterprise stage makes use of Teradata Fast Load to load a temporary (empty) table and then insert into the target table thus providing what looks like an Append.
Hope this clears up the confusion. So when you speak to the Teradata centric folks ,don't tell them Fast Load to append. That will drive them
Hope this clears up the confusion. So when you speak to the Teradata centric folks ,don't tell them Fast Load to append. That will drive them
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Have a look at this blog post Datastage 7x Enterprise Editionwith Teradata , it has details about Teradata Utilities (& how) which can be used in DataStage.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>