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

How do you set the session mode parameters in bteq?

0 Answers  


what is the default character set in teradata,,?

2 Answers   IBM, TCS,


Difference between inner join and outer join?

0 Answers  


How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


what is meant by Hot amp?

2 Answers   IBM, Satyam,






What do you mean by parsing?

0 Answers  


can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,


How to identify ppi columns?

0 Answers  


we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,


What is meant by a Virtual Disk?

0 Answers  


What are types of partition primary index (ppi) in teradata?

0 Answers  


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

0 Answers  


Categories