Interested to Buy Any Domain ? << Click Here >> for more details...
Can u load same data into multiple tables using multiload?
How will be the loading process? Whether it will be serially
or parallely?
- 2 Answers
- 9475 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
1. yes it is possible.
2. use single begin statement, use different layouts. two
dml statements. two import statements.
3. it would be parallel.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / tdguy
yes possible, provided both the tables have same structure.
Just two layouts, dml and import statements would do.
| Is This Answer Correct ? | 2 Yes | 0 No |
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are some commonly used bteq scripts?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
What do high confidence, low confidence and no confidence mean in explain plan?
How will you solve the problem that occurs during update?
What is meant by a Least Cost Plan?
During the Display time, how is the sequence generated by Teradata?
Why is the case expression used in teradata?
The transaction exceeded the maximum number of rowhash locks allowed
Find 2 highest sal from each dept who have completed 5 year in org
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Teradata 
