Answer / syed naseruddin

materailized views are useful in two in datastage
1)when we are loading data from standard interface(staging
area) to dataware house
2)from datawarehose to reporting area


note:standard interface means---->in this arera we are
going to load the standerzie data using datastage from
differnet flat files and staging area.
on top of standerdized data we perform transformations


so,after performing transformations according to bussines
requirments we will load data to warehouse in between this
we material viwes to automatically referesh the data

same way when we are loading data from warehouse to
reporting purpose

Answer / hari

Hi Kpk

I Think u r answer correct in Oracle view but question is
how can we use the materilized views in dataStage.

My view is No need of materialized view in DataStage it can
be used in Reporting time ( in OLAP)

Answer / kpk

Materilized views are similar to normal views, but the
difference is, materilized views are stored in the databse
and they are refereshed timely to get the new data....

Answer / srinu

materialized views are used in lookup stage,for data refernces in local machine.these does not import physical data into local machine just refernces by using materialized views

How can we run same job in 1 day 2 times

4 Answers   IBM,

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

---

Differentiate between validated and Compiled in the Datastage?

0 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

Define Job control?

0 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

Difference between data warehousing and olap?

0 Answers  

---

what is use of SDR function?

0 Answers   CGI,

---

What is the sortmerge collector?

0 Answers  

---