what is usage of datastage with materialized views
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between an operational datastage and a data warehouse?
Whats difference betweeen operational data stage (ods) and data warehouse?
Explain how a source file is populated?
What are the different kinds of views available in a datastage director?
How to find value from a column in a dataset?
What are transforms and what is the differenece between routines and transforms?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are some prerequisites for datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Have you have ever worked in unix environment and why it is useful in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between data warehousing and olap?
What all the types of jobs you developed?
Is the value of staging variable stored temporarily or permanently?
CHANGE CAPTURE