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
Explain the term 'row' related to relational database management system?
What is the opening step in basic teradata query script?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the updated features of teradata?
How many types of joins are there in teradata?
How can bottlenecks be identified?
What is spool space?
How many codd's rules are satisfied by teradata database?
What is the difference between teradata and basic rdbms?
Difference between inner join and outer join?
What are the primary characteristics of the Teradata.
What is the use of fallback?
During the Display time, how is the sequence generated by Teradata?
What is the function of parser component in teradata?
What is primary index and secondary index?