Why do we use DSS database for OLAP tools?

Answers were Sorted based on User's Feedback



Why do we use DSS database for OLAP tools?..

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

Why do we use DSS database for OLAP tools?..

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

Post New Answer

More Informatica Interview Questions

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


What are the phases in SDLC?

3 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


what is the location of parameter file in informatica?

1 Answers   TCS,






what is mean by flag 4 in update strategy t/r

6 Answers  


How to load a Dimension ? and how to load a fact table?

0 Answers  


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


what is datamart

4 Answers   IBM, Informatica,


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


Categories