Difference between ODS and Staging
Answer Posted / pravin
Operational Data store is a subject
oriented,integrated,current,volatile collection of data
used to support the tactical decision making process for
the enterprise. It is the central point of data integration
for busienss management,delivering a common view of
enterprise data.
In Staging Area you are carried out ETL operations as per
your business logic in order to fetch processed information
into data ware house.
| Is This Answer Correct ? | 9 Yes | 12 No |
Post New Answer View All Answers
Explain a mapping, session, worklet, workflow, mapplet?
what is difference between drill & scope of analysis?
what are the other factors of the database on which the loading performance depend?
What are different deliverables according to phases?
Explain what is power center repository?
Suppose we want to display zero when null values coming to report how can we do that?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are the various tools? Explain name a few?
What is Cognos script editor?
Explain where do we use semi and non additive facts?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What do you mean by static and local variable?
How do you define data block size?
What are session timeout and application timeout? Where we have to do this process?
What are the various methods of getting incremental records or delta records from the source systems?