Can u load same data into multiple tables using multiload?
How will be the loading process? Whether it will be serially
or parallely?

Answers were Sorted based on User's Feedback



Can u load same data into multiple tables using multiload? How will be the loading process? Whether..

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

Can u load same data into multiple tables using multiload? How will be the loading process? Whether..

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

Post New Answer

More Teradata Interview Questions

What is the difference between teradata and oracle?

0 Answers  


What do you mean by ttu in teradata?

0 Answers  


How is MLOAD Teradata Server restarted after execution?

0 Answers  


Highlight the differences between Primary Key and Primary Index.

0 Answers  


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

0 Answers  






Highlight a few of the important components of Teradata?

0 Answers  


Explain the term 'tables' related to relational database management system?

0 Answers  


what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,


Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  


Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,


How do you eliminate duplicates?

3 Answers  


why varchar takes 2 extra bytes?

4 Answers   IBM,


Categories