what is usage of datastage with materialized views
- 4 Answers
- 14599 Views
- HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between the local container and shared container?
What is the difference between datastage and informatica?
What is meta stage?
How the ipc stage work?
how to export or import the jobs in .ISX file
Why we use surrogate key?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Can you explain tagbatch restructure operator?
What is the difference between account and directory options ?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is difference between symmetric multiprocessing and massive parallel processing?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Why fact table is in normal form?
