1. generally how many node system will be used by the client.
2. while running mload if the job is aborted/failed at any
phase what we have to look after to run the job successfully?
3.i wanted to know how to write the fastload script for
table creation as well as table loading in a single script?
Answer Posted / yuvaevergreen
1. As said above, the requirement drives the no of nodes to
be connected. But, for millions of data, generally, 10 nodes
may be used
2.release mload, drop the log table,work table,error table
and submit the mload if the table needs to be loaded from first.
3.Log onto Teradata,Defining the Teradata table that you
want to load (target table),Defining the INPUT data file,
Telling the system to start loading.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does sleep function does in fast load?
What is the multi-insert?
What are the primary characteristics of the Teradata.
What is the opening step in basic teradata query script?
Explain amp in teradata?
How do you define Teradata?
What do you mean by teradata intellicloud?
what are the uses of fact table and dimension table in banking project?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How can we check the version of Teradata that we are using currently?
What is a sparse index?
What are the functions involved in shared information architecture?
What are the different softwares used with their functions in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
Explain teradata utilities?