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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1902


What are the different softwares used with their functions in teradata?

583


What is meant by a Parsing Engine?

711


how do you manage the production space. what are the proactive methods you can take ?

1483


What is the difference between fastload and multiload? Which one is faster?

603






What is a node in teradata?

589


What are the various indexes in teradata? How to use them?

573


what is sysdba and sysdbc ? which has high priority ?

3377


What is the syntax for case when statement?

594


Explain how spool space is used.

623


what are the day to day activities of teradata DBA ?

5378


What do you mean by ttu in teradata?

575


What is bteq utility in teradata?

575


In Teradata, what is the significance of UPSERT command?

597


What are the various reporting tools in the market?

620