Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

What are the things to be considered while creating secondary index?

0 Answers  

---

what do you mean by INMOD Routines and OUTMODE Routines ?

3 Answers  

---

List out all forms of LOCKS that are available in Teradata.

0 Answers  

---

What are the scenarios in which full table scans occurs?

0 Answers  

---

---

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

---

Syntax for case when statement?

0 Answers  

---

Comment whether bottleneck is an error or not.

0 Answers  

---

What is logical data model?

0 Answers  

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,

---