Interested to Buy Any Domain ? << Click Here >> for more details...
Why MLOAD needs Work Tables?
- 5 Answers
- 24264 Views
- Teradata, I also Faced
- E-Mail Answers
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 |
Explain and compare pros and cons of snow flake schemas?
What are two examples of an OLTP environment?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Can you fastexport a field, which is primary key by putting equality on that key?
What is the basic syntax for teradata select statement?
what is the difference between filter and router transmissions
What are the different functions performed in development phase?
What is the process to restart the multiload if it fails?
In the Primary Index, what is the score of AMPs that are actively involved?
Teradata 
