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 can you track login parameters of users in teradata?

1148

---

What are the steps involved after the disk manager passes the request?

1062

---

What is a three-tier data warehouse?

1072

---

What are the various reporting tools in the market?

1012

---

What are the available join types in teradata?

1029

---

What is upsert statement in teradata?

1076

---

Explain teradata architecture?

1051

---

What are the updated features of teradata?

1009

---

What is meant by a Clique?

1015

---

Why is the case expression used in teradata?

1041

---

if collect stats but it show low confidence why?

1650

---

What are the components provided on node?

1000

---

What is meant by a Highest Cost Plan?

1012

---

What are types of partition primary index (ppi) in teradata?

1019

---

What is the command in bteq to check for session settings ?

1139

---