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 is object level locking ? where do appear this type of locking ?
If a Node is busy what are the steps you can take to avoid ?
What are the available primary index types?
Explain how spool space is used.
what are the day to day activities of teradata DBA ?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the function of parser component in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is a node in teradata?
Explain teradata vs. Redshift?
Difference between stored procedure and macro?
Explain the advantages of partitioned primary index in a query?
What are the available join types in teradata?
Explain PDE.
What is meant by a Clique?