Answer Posted / vinay sir(datawarehousing tech

Guys, Small correction to the above answer.
Please read this latest answer.
There are 2 ways
1.Incase of Old file to Run
Dont drop error tables simply rectify the error in the
script or file and Run again.so that it runs from last
configuration.
2.Incase of new file to Run
Drop Error tables
Try to run the script with only begin and end loading
statements. ,so that it relases the lock on target table.
If possible remove the record from fastlog table.
Run the script with new file freshly.

What is collect statistics?

1000

---

Explain the term 'foreign key' related to relational database management system?

1043

---

What is teradata? Also, list out some of the primary characteristics of teradata.

1060

---

What are the various etl tools in the market?

1073

---

What are the various reporting tools in the market?

1072

---

Syntax for case when statement?

1067

---

What are the design features involved in teradata?

1058

---

What are teradata utilities?

1111

---

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?

1113

---

What are the components used in smp and massively parallel processing (mpp) machines?

1057

---

What are differences between teradata and ansi session modes in teradata?

1175

---

Can you connect multiload from ab initio?

1215

---

What is multi insert?

1052

---

What is the purpose of joins in teradata?

1190

---

When tpump is used instead of multiload?

1105

---