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

What are the features of datastage flow designer?

1 Answers  

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

1 Answers   Wipro,

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

Difference between data warehousing and olap?

1 Answers  

---

Where the datastage stored his repository?

1 Answers  

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

1 Answers  

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

Define APT_CONFIG in Datastage?

1 Answers  

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1 Answers  

---