Why MLOAD needs Work Tables?

Answer Posted / anil

Whne you loading data it's not load directly to amp,first
it load to work load at the 4 stage it loads from work
table to target table,Then after final stage it's delete
the work tables and error tables every thing

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the things to be considered while creating secondary index?

633


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1669


What is the meaning of Caching in Teradata?

695


How do you create tables? Exact syntax, and create profiles, users in teradata?

558


What is teradata? Also, list out some of the primary characteristics of teradata.

579






What is stored procedure in teradata?

588


What is multi insert?

628


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

375


What are the multiload utility limitations?

595


What are the commands to make a new table, change a table and remove a table in teradata?

611


What is the use of fallback?

560


Which is faster fastload or multiload?

597


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

575


What is meant by a node?

619


What are the various reporting tools in the market?

617