Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7124 Views
- I also Faced
- E-Mail Answers
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
Why is the case expression used in teradata?
Explain the new features of teradata?
What are the frequently used data types in teradata?
Explain teradata utilities?
Explain the most common data types used in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is upsert statement in teradata?
In Teradata, how do we Generate Sequence?
What is oltp?
Highlight all the modes that are present under Confidence Level.
What is a clique?
If a Node is busy what are the steps you can take to avoid ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How do you verify a complicated sql?
Why teradata is used?
