Answer Posted / vinay sir(datawarehousing tech

Little more clear description for the above two answers.

RELEASING LOCKS IN MLOAD:
We need to use the below RELEASE MLOAD command in BTEQ.

Acquisition Phase: RELEASE MLOAD TABLE1....TABLE5
Application Phase: RELEASE MLOAD TABLE1....TABLE5 in Apply

RELEASING LOCKS IN FASTLOAD:
Assue the table is Party and it is using ERparty and UVparty
tables as its error tables.Then use the below script(Called
Empty Script) for allowing operatins on the Party table.

.logon <>
database VINAY;
BEGIN LOADING Party
ERRORFILES ERparty,UVParty
CHECKPOINT 10;

END LOADING;
.logoff

How to select first n records in teradata?

1100

---

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

1170

---

How can you track login parameters of users in teradata?

1189

---

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?

1107

---

What is collect statistics?

996

---

What is difference between user and database in teradata?

1065

---

What do you mean by caching in teradata?

1062

---

Define views in teradata with syntax.

1075

---

How do you do backup and recovery in teradata?

1014

---

Highlight the need for Performance Tuning.

1103

---

What are the various indexes in teradata? How to use them?

1009

---

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

1079

---

What is real time and near real time data warehousing?

1115

---

How many tables can you join in v2r5?

1067

---

What is meant by Teradata Gateway?

1058

---