Answer Posted / santhosh kumar burada

Hi..!!

i think, when we are going for Fload the target table will be
SET table so, that will not support for duplicate values..
in NUSI we have duplicate values, so that will not support..
in Mload target table will be any thing, either SET or Multiset.. so that will support..

Thank you..
Santhosh kumar.B

What is collect statistics?

998

---

List out teradata data types?

1006

---

Explain BYNET.

994

---

Name the five phases that come under MultiLoad Utility.

982

---

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

1169

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1107

---

What is the command in bteq to check for session settings ?

1180

---

Define views in teradata with general syntax.

1025

---

When tpump is used instead of multiload?

1100

---

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

1076

---

What is multi insert?

1045

---

Explain the term 'row' related to relational database management system?

949

---

What do you mean by teradata intelliflex?

1090

---

What does sleep function does in fast load?

1135

---

How to eliminate product joins in a teradata sql query?

1022

---