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

Why does varchar occupy 2 extra bytes?

1193

---

What are the various etl tools in the market?

1073

---

What are the enhanced features in teradata v2r5 and v2r6?

1138

---

What's the difference between timestamp (0) and timestamp (6)?

1196

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

---

What are the different table types that are supported by teradata?

1003

---

What is logical data model?

1205

---

any one answer me how they can analyzing the project using data ware housing?

2480

---

How can we check the version of Teradata that we are using currently?

1069

---

What is the multi-insert?

1034

---

What is primary index and secondary index?

1028

---

Explain teradata vs. Redshift?

1023

---

Explain teradata architecture?

1094

---

Differentiate primary key and partition key?

983

---

Explain the types of join supports by teradata?

995

---