Interested to Buy Any Domain ? << Click Here >> for more details...
what is usage of datastage with materialized views
- 4 Answers
- 16435 Views
- HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / syed naseruddin
materailized views are useful in two in datastage
1)when we are loading data from standard interface(staging
area) to dataware house
2)from datawarehose to reporting area
note:standard interface means---->in this arera we are
going to load the standerzie data using datastage from
differnet flat files and staging area.
on top of standerdized data we perform transformations
so,after performing transformations according to bussines
requirments we will load data to warehouse in between this
we material viwes to automatically referesh the data
same way when we are loading data from warehouse to
reporting purpose
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the purpose of pivot stage and types of containers in datastage
Define Job control?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is a merge in datastage?
How to reverse the string using SQL?
What is the project in datastage?
Difference between server jobs & parallel jobs?
Describe link sort?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
root tree will find which is server job and which is parallel job?
What is the difference between account and directory options ?
Can you filter data in hashed file?
How a routine is called in datastage job?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
