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?
Answers were Sorted based on User's Feedback
Answer / ugandhar
1) It depends on the requirement. Generally around 10 node
system will be a moderate to high dataware house
environments.
2) Check the log file to know the exact failure. Fix it, do
the mlod cleanup and rerun the job.
3) specify the table craetion step in the beginning of the
script before the actual fastload commands starts.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What are the steps to create a data model?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain parsing engine in teradata?
what is identity columns in TD?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
Fast Load Script is failed and error tables are available then how do you restart?
Explain the advantages of partitioned primary index in a query?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
in teradata level primary in table level allows duplicates why?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What is FILLER command in Teradata?
what is the difference between bpo and call centre?