what is usage of datastage with materialized views
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
what is the use of materialized view?
What are the components of ascential data stage?
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 ?
Describe link sort?
Differentiate between odbc and drs stage?
Define Job control?
Define Merge?
Explain connectivity between datastage with datasources?
What is the difference between informatica and datastage?
What all the types of jobs you developed?
what is use of SDR function?
Triggers,VIEW,Procedures
What is usage analysis in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the different common services in datastage?