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

Describe the set operators in teradata.

591


Why do you get spool space errors? How do trouble-shoot them?

605


What are the available primary index types?

724


How to run a query in teradata?

591


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

644






What are the string manipulation operators and functions associated with teradata?

647


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

652


What do you mean by teradata sql assistant?

602


What are the frequently used data types in teradata?

608


Explain the types of join supports by teradata?

596


What is node? How many nodes and amps used in your previous project?

685


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

580


Explain and compare pros and cons of snow flake schemas?

619


What tools would you use for that?

580


What are aggregate tables? How do you design them using teradata?

645