How do you load Multiple files to a table by using fastload
scripts?

Answer Posted / vinay

Remove End Loading statement in the script and Replace the
file one by one in the script till last file and submit
everytime so that data appended in Amp Level.
For the last file specify End Loading stmt in the script
and Run.so that it runs frm Amp to table.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why managing the data is important?

770


What is a level of granularity of a fact table?

836


how many modules are there in telecome domain?how to explain the architecture?

1779


Difference between star and snowflake schemas?

820


In Teradata, how do we Generate Sequence?

805


Highlight the advantages of PPI(Partition Primary Index).

794


How to view every column and the columns contained in indexes in teradata?

809


Why does varchar occupy 2 extra bytes?

846


What is the purpose of joins in teradata and what are the available join types?

777


How is the teradata different from oracle?

833


What does Amp contain and what are all the operations that it performs?

782


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

838


List the logical and conditional operators that are used with teradata along with their meanings?

760


What are the frequently used data types in teradata?

802


What are the available join types in teradata?

816