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
How to use pmcmd utility command?
What is meant by pre and post session shell command?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Have you worked with/created Parameter file
Explain about Informatica server process that how it works relates to mapping variables?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
update strategy transformation in informatica
How to generate sequence numbers?
How can repository reports be accessed without sql or other transformations?
How to configure mapping in informatica?
What do you mean by blocking transformation?
Clarify the aggregator change?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to load the data from people soft hrm to people soft erm using informatica?
What are the main issues while working with flat files as source and as targets ?
