Interested to Buy Any Domain ? << Click Here >> for more details...
what is usage of datastage with materialized views
- 4 Answers
- 16812 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 are constraints and derivations?
how to implement scd2 in datastage 7.5 with lookup stage
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What all the types of jobs you developed?
What are the different plug-ins stages used in your projects?
Differentiate between hash file and sequential file?
how many rows sorted in sort stage by default in server jobs
What is difference between symmetric multiprocessing and massive parallel processing?
What are some prerequisites for datastage?
Differentiate between datastage and datastage tx?
What are stage variables, derivations and constants?
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 you can fix the truncated data error in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between server job and parallel jobs?
