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
- 9572 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 |
Highlight the need for Performance Tuning.
What is the primary index in teradata?
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?
Why does varchar occupy 2 extra bytes?
What is the diffrence between Multiload & Fastload interms of Performance?
What is the purpose of using case expression in teradata?
What are the different table types that are supported by teradata?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
What do you mean by caching in teradata?
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
What happens when a node suffers a downfall?
How to cast date "2015-03-03-012204-000000" to timestamp
Teradata 
