Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Why MLOAD needs Work Tables?

Answers were Sorted based on User's Feedback

Why MLOAD needs Work Tables?..

Answer / lilian

Work Tables are used to receive and sort
data and SQL on each AMP prior to storing them permanently
to disk.
The purpose of worktables is to hold two things:
1. The Data Manipulation Language (DML) tasks
2. The input data that is ready to APPLY to the AMPs
MultiLoad will automatically create one worktable for each
target table. This means that in IMPORT
mode you could have one or more worktables. In the DELETE
mode, you will only have one worktable since that
mode only works on one target table.

Is This Answer Correct ?    15 Yes 3 No

Why MLOAD needs Work Tables?..

Answer / 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

Why MLOAD needs Work Tables?..

Answer / yuvaevergreen

Adding to the above, the work tables are created in
permanent space and used by the amps. Be aware of the
estimated perm space so that mload performance would be good.

Is This Answer Correct ?    6 Yes 1 No

Why MLOAD needs Work Tables?..

Answer / 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

Why MLOAD needs Work Tables?..

Answer / tdguy

Work tables are created during the preliminary phase. This
table holds the input data.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

Explain the advantages of partitioned primary index in a query?

0 Answers  

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

What is the maximum number of dml can be coded in a multiload script?

0 Answers  

What are the enhanced features in teradata v2r5 and v2r6?

0 Answers  

How to run the Teradata jobs in unix environment ???

4 Answers   IBM,

Explain how spool space is used.

0 Answers  

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

Difference between inner join and outer join?

0 Answers  

How can we check the version of Teradata that we are using currently?

0 Answers  

Difference between Qualify and group

4 Answers   CTS,

What is meant by a node?

0 Answers