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 the difference between STOP and ABORT options in Workflow Monitor?
What is joiner transformation?
How to join three sources using joiner? Explain though mapping flow.
What is a stored procedure transformation?
Explain lookup transformation source types in informatica
generate date / time dimension in informatica
What are Dimensional table?
How to start a workflow using pmcmd command?
How to call shell scripts from informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain the difference between mapping parameter and mapping variable?
What is meant by LDAP users?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Why do we need informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?