Interested to Buy Any Domain ? << Click Here >> for more details...
what is usage of datastage with materialized views
- 4 Answers
- 16622 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
What is the difference between an operational datastage and a data warehouse?
On which Dimension Table you implemented SCD Type in your Project
How can we improve performance of data stage jobs?
What is the project in datastage?
Explain entity, attribute and relationship in datastage?
How will you move hashed file from one location to another location?
Is the value of staging variable stored temporarily or permanently?
What are the processing stages?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Explain usage analysis in datastage?
What is apt_config in datastage?
Can you explain kafka connector?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to export or import the jobs in .ISX file
