Why MLOAD needs Work Tables?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / tdguy
Work tables are created during the preliminary phase. This
table holds the input data.
Is This Answer Correct ? | 1 Yes | 0 No |
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
List out all forms of LOCKS that are available in Teradata.
Where is teradata rdbms used?
can i call router is a passive transformation
What is FILLER command in Teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the uses of client software involved in teradata?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What is upsert statement in teradata?
how many modules are there in telecome domain?how to explain the architecture?
Define views in teradata with general syntax.