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 |
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
In Teradata, what is the significance of UPSERT command?
Different phases of multiload?
What is the syntax for case when statement?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What is a common data source for the central enterprise data warehouse?
what do you mean by INMOD Routines and OUTMODE Routines ?
What is difference between user and database in teradata?
Highlight all the modes that are present under Confidence Level.
What is the difference between correlated sub queries and inner queries?
where we can use the delimiter in mload? pls let me know
What is teradata?