Answer / prasoon

operational data stores (ODS)

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  

---

How to relege locks in fastload and multiload? example?

4 Answers   IBM,

---

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  

---

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

---

---

Can we load a Multi set table using MLOAD?

2 Answers  

---

how to load or extract the error table data ?

3 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  

---

can i call router is a passive transformation

2 Answers  

---

Why Multiload does not supports USI and supports NUSI?

4 Answers  

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---