All Forums Database
adiideas1 4 posts Joined 02/13
13 Mar 2013
Fastload: Can it Transfer data from One table to another Empty table?

Folks,
I have just stepped in Teradata world.
Have a query on Fastload.
1. Can Fastload be used to Transfer Data from Table A to Table B [Empty table]?
2. If yes, does it need to use the INMOD functionality to read data from Table A?
3. In this case, From Performance point of view, which one is best a] Fastload b] Using SQL to Transfer data. And Why?
Best,
Adi
 
 

Thanks
dnoeth 4628 posts Joined 11/04
14 Mar 2013

Hi Adi,
#1: yes, insert/select
#2: of course not
#3: b) Insert/Select into an empty table is highly optimized without Transient Journal (even better when PI/partitioning match and column definition, too)
Dieter

Dieter

adiideas1 4 posts Joined 02/13
15 Mar 2013

Hi Dieter,
Thanks for response!
Could you please post syntax of Fastload reading from table?
Also the no of sessions we provide in Fastload script, how do we decide on that. Say I want to load a 20 GB file. It would not be nice to specify sessions which takes too much resources.
So how do we decide on Optimum session number so as NOT to strain the system and get the job done optimally?
 
Again, Thanks for response!!
Best,
Adi
 
 
 
 
 

Thanks

dnoeth 4628 posts Joined 11/04
15 Mar 2013

Hi Adi,
sorry, i was wrong for #1, you can't use Ins/Sel in a FastLoad, only Delete and Drop/Create Table is allowed (before BEGIN LOADING).
But there's no need to use FastLoad for that purpose, simply run it as-is using BTEQ.
Dieter
 

Dieter

adiideas1 4 posts Joined 02/13
15 Mar 2013

Thanks Dieter.
Could you share how to determine no of sessions for fastload optimally without straining system resources and getting job done optimally?
 
Best,
ADi
 

Thanks

You must sign in to leave a comment.