How do you load Multiple files to a table by using fastload
scripts?
Answer / 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 |
How to identify ppi columns?
Mention a few of the ETL tools that come under Teradata.
How to cast date "2015-03-03-012204-000000" to timestamp
How can bottlenecks be identified?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Why managing the data is important?
What is collect statistics?
how can we analyze the locks ?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
How a Referential integrity is handled in Teradata?
How to eliminate product joins in a teradata sql query?
What do you mean by tpt in teradata?