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 exactly do you know about catching in teradata?

1078

---

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

1215

---

What is the purpose of using case expression in teradata?

1064

---

What is collect statistics?

1048

---

Different phases of multiload?

1063

---

If a Node is busy what are the steps you can take to avoid ?

2456

---

How to Extract data from multiple legacy systems?

1172

---

What are the available primary index types in teradata.

1078

---

Explain how spool space is used.

1111

---

Differentiate database data and data warehouse data?

1162

---

What is node? How many nodes and amps used in your previous project?

1153

---

Explain the advantages of partitioned primary index in a query?

1070

---

What are some commonly used bteq scripts?

1058

---

What is oltp?

1013

---

What tools would you use for that?

1154

---