Answer / yuvaevergreen

dynamic sql is invoking SQL inside a stored procedure during
run time. execute immediate or call can be used to invoke
dynamic sql.

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 Answers  

---

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

How do you define Teradata?

0 Answers  

---

Differentiate database data and data warehouse data?

0 Answers  

---

What are the steps to create a data model?

0 Answers  

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  

---

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

---

What can be achieved by using the teradata rdbms?

0 Answers  

---

how can we analyze the locks ?

0 Answers   HP,

---

List out teradata data types?

0 Answers  

---