what is usage of datastage with materialized views
- 4 Answers
- 14600 Views
- HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do y read Sequential file from job control?
What is the difference between passive stage and active stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How do you reject records in a transformer?
How can we improve the performance in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
whom do you report?
Can you implement SCD2 using join, transformer and funnel stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Can we use target hash file as a lookup ?
What is the flow of loading data into fact & dimensional tables?
client know skid info?
What is data partitioning?
What are the steps needed to create a simple basic datastage job?
Triggers,VIEW,Procedures
