Interested to Buy Any Domain ? << Click Here >> for more details...
what is usage of datastage with materialized views
- 4 Answers
- 16815 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
Describe routines in datastage? Enlist various types of routines.
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
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.
How a server job can be converted to a parallel job?
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 ?
What are the processing stages?
Is possible to create skid in dim,fact tables?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Can you implement SCD2 using join, transformer and funnel stage?
How do you import and export the datastage jobs?
Is the value of staging variable stored temporarily or permanently?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Have you have ever worked in unix environment and why it is useful in datastage?
What all the types of jobs you developed?
What is the importance of the exception activity in datastage?
