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
- 7284 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
What does sleep function does in fast load?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the use of fallback?
Different phases of multiload?
How to find duplicates in a table?
Write a program to show the parser component used in teradata?
In Teradata, how do we Generate Sequence?
How many sessions of MAX is PE capable of handling at a particular time?
What is the opening step in basic teradata query script?
What is the difference between teradata and basic rdbms?
what are the uses of fact table and dimension table in banking project?
What is primary index and secondary index?
What are some commonly used bteq scripts?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is meant by a Virtual Disk?
