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

What do you mean by ttu in teradata?

970

---

How is the teradata different from oracle?

1032

---

What are the scenarios in which full table scans occurs?

938

---

Can we collect statistics on multiple columns?

986

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

925

---

Explain how spool space is used.

1017

---

What is dimensional modeling?

1010

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2094

---

How can bottlenecks be identified?

955

---

What are some primary characteristics of teradata?

943

---

What is primary index and secondary index?

972

---

What is teradata and why it is used?

1011

---

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

953

---

What is database exceptions in teradata?

894

---

What is the maximum number of dml can be coded in a multiload script?

1047

---