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
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 |
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 |
teradata support to automatically increase the character length or not?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
Does SDLC changes when you use Teradata instead of Oracle?
What is meant by a Least Cost Plan?
what is the default character set in teradata,,?
What is the purpose of upsert command?
If table have access lock.In the same table write lock is posible or not?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Name the five phases that come under MultiLoad Utility.
In Teradata, how do we Generate Sequence?
What is meant by a Virtual Disk?
Aborted in Phase 1 data Acquistion Incomplete in fastload?