what is usage of datastage with materialized views

Answers were Sorted based on User's Feedback



what is usage of datastage with materialized views..

Answer / 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

what is usage of datastage with materialized views..

Answer / 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

what is usage of datastage with materialized views..

Answer / 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

what is usage of datastage with materialized views..

Answer / srinu

materialized views are used in lookup stage,for data refernces in local machine.these does not import physical data into local machine just refernces by using materialized views

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Data Stage Interview Questions

Which algorithm you used for your hashfile?

0 Answers  


I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  


To see hidden files in LINIX?

0 Answers   CTS,


Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


how to write server Routine coding?

0 Answers   Eric,


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,


What is a datastage job?

0 Answers  


Differentiate between data file and descriptor file?

0 Answers  


in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,


Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,


1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,


Categories