Why MLOAD needs Work Tables?

Answer Posted / varun

Work tables are created in the first phase of IMPORT task.
Work tables are created on each AMP for each target table.
They will hold the DML steps to be performed as well as the
input data to be applied.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved after the disk manager passes the request?

580


how many modules are there in telecome domain?how to explain the architecture?

1557


Differentiate database data and data warehouse data?

588


Can you fastexport a field, which is primary key by putting equality on that key?

711


What is the difference between teradata and basic rdbms?

569






What is a node in teradata? Explain

603


Explain the term 'database' related to relational database management system?

575


Different phases of multiload?

594


How many tables can you join in v2r5?

626


What are different table types used in teradata?

587


What are the components used in smp and massively parallel processing (mpp) machines?

599


What is smp and mpp platforms?

527


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1281


Explain the types of join supports by teradata?

587


What is dimensional modeling?

594