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 |
can any one give some examples for pre sql and post sql(Except dropping and creating index).
whether Sequence generater T/r uses Caches? then what type of Cache it is
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Explain informatica architecture - version 8 / 9
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Which will beter perform IIf or decode?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
What is a dimensional model?
What is the status code?
what is the flow?
How can we handle two sessions in informatica?