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

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  


Mention a few of the ETL tools that come under Teradata.

0 Answers  


what are the day to day activities of teradata DBA ?

0 Answers   TCS,


In BTEQ, how are the session-mode parameters being set?

0 Answers  






what is amp plz explanation

5 Answers   IBM,


What is the use of having index on table?

0 Answers  


How do you see a ddl for an existing table?

0 Answers  


What are the various etl tools in the market?

0 Answers  


What is the function of parser component in teradata?

0 Answers  


What is FILLER command in Teradata?

9 Answers   CTS, IBM,


Comment whether bottleneck is an error or not.

0 Answers  


Categories