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
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 ?
What are the different softwares used with their functions in teradata?
What is meant by a Parsing Engine?
how do you manage the production space. what are the proactive methods you can take ?
What is the difference between fastload and multiload? Which one is faster?
What is a node in teradata?
What are the various indexes in teradata? How to use them?
what is sysdba and sysdbc ? which has high priority ?
What is the syntax for case when statement?
Explain how spool space is used.
what are the day to day activities of teradata DBA ?
What do you mean by ttu in teradata?
What is bteq utility in teradata?
In Teradata, what is the significance of UPSERT command?
What are the various reporting tools in the market?