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
Why do you use Mapping Parameter and mapping variable?
What do mean by local and global repository?
What are the prerequisite tasks to achieve the session partition?
Why update strategy and union transformations are active?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the differences between joiner transformation and source qualifier transformation?
How to implement security measures using repository manager?
Design a mapping to load a target table with the following values from the above source?
What is lookup transformation?
What is dimensional table?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How is union transformation utilized?
How would you copy the content of one repository to another repository?
What is a filter transformation?
What is meant by LDAP users?