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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
what is flow of project?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Can you explain repository tables in datastage?
AGGREGATOR default datatype
table actions available in oracle connector?
How to perform incremental load in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
If you want to use a same piece of code in different jobs, how will you achieve this?
Explain datastage architecture?
How to RD using transformer?
What is the difference between datastage and datastage tx?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
CHANGE CAPTURE