Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / himanshu
OLTP : Online Transaction Processing
The granularity of the data is Transaction i.e. stores each
transaction.
ODS: Operational Data Store
As dataware house contains summarized data
(Weekly/Monthly/Yearly). ODS may be used to maintain data
with lower granilarity (Hourly/Daily).
eg. Data for previous years may be summarized but sould not
be for the current year.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Whats there in global repository
What are the new features of informatica 9.x in developer level?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What all are steps in up gradation of Informatica server?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is the size of your data warehousing?
What is Cognos script editor?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the etl program with few examples.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Mention a few design and development best practices for informatica?
Enterprise data warehouse your projects phase by phase explain?
How might you approve all mappings in the archive all the while?
What are the prerequisite tasks to achieve the session partition?
How are indexes created after completing the load process?
