Answer Posted / gowthami

Thanks alot nitin for ur rly.

i would like share 1 interview question which was asked in
ibm.

Q)there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.

thanks in advance

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

1001

---

what is object level locking ? where do appear this type of locking ?

3448

---

What is a level of granularity of a fact table?

1074

---

What is difference between user and database in teradata?

1027

---

What is TPD?

1308

---

Describe the set operators in teradata.

954

---

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

928

---

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

2095

---

What are the components used in smp and massively parallel processing (mpp) machines?

1004

---

What is oltp?

916

---

What is meant by a Virtual Disk?

1048

---

Mention a few of the ETL tools that come under Teradata.

1015

---

In BTEQ, how are the session-mode parameters being set?

1089

---

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 ?

2421

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1042

---