Can u load same data into multiple tables using multiload?
How will be the loading process? Whether it will be serially
or parallely?
- 2 Answers
- 8762 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is a common data source for the central enterprise data warehouse?
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
What are the different methods ot loading a dimension table? A fact table etc?
can we load 10 millions of records into target table by using tpump?
I want to write one query How to get Matched records and unmatched records in table?
What is the purpose of joins in teradata?
Define views in teradata with syntax.
What are the functions involved in shared information architecture?
what are the roles and responsibilities of teradata DBA ?
What is difference between user and database in teradata?
What are the functions performed by bynet?
Teradata 
