Answer Posted / vishvajeet solanke

TRY THIS ONE..ITS SIMPLE


CREATE VOLATILE TABLE TEST
(e_NAME VARCHAR(10),SUB1 INTEGER,SUB2 INTEGER,SUB3 INTEGER)
ON COMMIT PRESERVE ROWS;

INSERT INTO TEST (e_NAME,SUB1,SUB2,SUB3) VALUES('AAA',85,95,92);
INSERT INTO TEST (e_NAME,SUB1,SUB2,SUB3) VALUES('BBB',75,67,82);

SEL E_NAME,MAX(SUBJECT) FROM
(SEL E_NAME,SUB1 AS SUBJECT
FROM TEST
UNION
SEL E_NAME,SUB2 AS SUBJECT
FROM TEST
UNION
SEL E_NAME,SUB3 AS SUBJECT
FROM TEST
) TS
GROUP BY 1

Can you fastexport a field, which is primary key by putting equality on that key?

1178

---

What interface is used to connect to windows based applications?

1115

---

what are the uses of fact table and dimension table in banking project?

4556

---

What are some commonly used bteq scripts?

1012

---

Explain and compare pros and cons of snow flake schemas?

1035

---

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

1066

---

How to Extract data from multiple legacy systems?

1122

---

What is called partitioned primary index (ppi)?

1013

---

What is the use of fallback?

996

---

How to select first n records in teradata?

1107

---

What do high confidence, low confidence and no confidence mean in explain plan?

1048

---

Define views in teradata with general syntax.

1034

---

How do you see a ddl for an existing table?

1018

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837

---

What does sleep function does in fast load?

1142

---