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
What is enterprise data warehousing?
Explain lookup transformation source types in informatica
What is flashback table ? Advance thanks
What is mapplet in informatica?
What are the tasks that source qualifier perform?
Explain the shared cache and re-cache?
Enlist few areas or real-time situations where informatica is required.
Explain sessions?
Informatica Checkpoints
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are session parameters ? How do you set them?
How can we store previous session logs?
generate date / time dimension in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a repository? And how to add it in an informatica client?
