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 create the source and target database connections in server manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What the difference is between a database, a data warehouse and a data mart?
What is meant by LDAP users?
What are the types of lookup transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain target update override in informatica
What are the modules in Power Center
Is stop and abort are same in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is flashback table ? Advance thanks
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the difference between a data warehouse and a data mart?
