what is usage of datastage with materialized views

Answers were Sorted based on User's Feedback



what is usage of datastage with materialized views..

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

Is This Answer Correct ?    1 Yes 0 No

what is usage of datastage with materialized views..

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)

Is This Answer Correct ?    1 Yes 2 No

what is usage of datastage with materialized views..

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....

Is This Answer Correct ?    2 Yes 4 No

what is usage of datastage with materialized views..

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

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Data Stage Interview Questions

How do you schedule or monitoring the job?

0 Answers  


Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  


Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  


plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,


What is RCP

5 Answers   CGI, CTS,






Enlist various types of routines in datastage.

0 Answers  


Describe the architecture of datastage?

0 Answers  


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

3 Answers   Tech Mahindra,


What are operators in datastage?

1 Answers  


Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,


What are the stages in datastage?

0 Answers  


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


Categories