Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas m
Hi Friends This is srinivas m,
DSS -> Decision Support System is Nothing But
OLAP -> Online Analytical Processing System
DSS or OLAP contains Historical Data..Used to make Decisions.. We cannot do any DML operations on datawarehouse.
Those were defined only for Reporting Purpose..
OLTP -> This is nothing but Our Oracle Database.. It contains Volatile Data. it will not maintain any historical data. The OLTP databases contains Current Data Only..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the types of schemas we have in data warehouse.
What do you mean by channel change?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is dynamic cache?
What are the advantages of using informatica as an etl tool over teradata?
Explain the tuning lookup transformation - informatica
Is there any way to read the ms excel datas directly into informatica?
What is a standalone command task?
What is informatica metadata and where is it stored?
What does reusable transformation mean?
What are the databases that informatica can connect to windows?
How to start a workflow using pmcmd command?
Performance tuning in UNIX for informatica mappings?
