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

Name the five phases that come under MultiLoad Utility.

995

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2488

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1112

---

Explain the types of join supports by teradata?

1000

---

What are the available primary index types in teradata.

1039

---

How can you track login parameters of users in teradata?

1200

---

Highlight the advantages of PPI(Partition Primary Index).

1082

---

What is basic teradata query language?

1122

---

What are the functions of a teradata dba?

1086

---

What is partitioned primary index (ppi)?

1055

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1085

---

What are different table types used in teradata?

1050

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1192

---

Why do you get spool space errors? How do trouble-shoot them?

1064

---

What is dimensional modeling?

1098

---