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 do you mean by fastexport in teradata?

643

---

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

635

---

List the logical and conditional operators that are used with teradata along with their meanings?

639

---

What is the difference between teradata and basic rdbms?

640

---

What is bteq script in teradata?

718

---

---

What is the use of stored procedures in teradata?

659

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3133

---

What is the opening step in basic teradata query script?

676

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

678

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

791

---

How is the teradata different from oracle?

712

---

What are some commonly used bteq scripts?

632

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

700

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

738

---

How to identify ppi columns?

741

---