Interested to Buy Any Domain ? << Click Here >> for more details...
what is usage of datastage with materialized views
- 4 Answers
- 16398 Views
- HP, TCS, I also Faced
- E-Mail Answers
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 are the important features of datastage?
What is orabulk stage?
What are datastage sequences?
EXPLAIN SCD
If you want to use a same piece of code in different jobs, how will you achieve this?
What is apt_config in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
sed,awk,head
What are the different types of lookups in datastage?
How to Remove Duplicate using SQL?
table actions available in oracle connector?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between datastage and datastage tx?
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?
how to add a new records into source?
