Answer / Shashi Prakash Verma

A Materialized View (MV) in SQL is a pre-computed, static version of a query result. It stores the result locally for faster access and to improve performance when querying large amounts of data frequently. MVs are particularly useful for complex or time-consuming queries.

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

how to find out number of records imported into source file?

1 Answers  

---

How do you reject records in a transformer?

1 Answers  

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1 Answers  

---

What are the different options associated with dsjob command?

1 Answers  

---

what is a nodemap constraint

2 Answers   IBM,

---

what is materialized view used datastage?

1 Answers   HSBC,

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

1 Answers   JPMorgan Chase,

---

in oracle target stage when we use load option and when we use upsert option?

1 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

Define Routines and their types?

1 Answers  

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---