Why do we use DSS database for OLAP tools?
Answers were Sorted based on User's Feedback
Answer / pushparao
DSS stands for decision support system.
it can used to implement effective decision making to
understood middle level management for OLAP systems.
that means reports are generated effectively in two and
multidimensional.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pranu
DSS database is optimized for running data queries that do not change the data. Since OLAP tools are used for analyzing data by running analytical queries, it is best to use DSS database
| Is This Answer Correct ? | 0 Yes | 0 No |
how i will stop my workflow after 10 errors
What are the different types of schemas?
Can I create one wrkflw which will run different wrkflws on schedule time?
What is union transformation?
In warehouses how many schemas are there?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the need of an ETL tool?
update strategy transformation in informatica
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
How do you remove duplicate records in informatica?