Why do we use DSS database for OLAP tools?

Question Posted / swetha

2 Answers
6805 Views
I also Faced
E-Mail Answers

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 diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers IBM, Wipro,

How do you change parameter when you move it from development to production.

1 Answers

Under which circumstances, informatica server creates reject files?

0 Answers Informatica,

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers HP,

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers

what are surrogate keys?

5 Answers

In joiner, how to load Master table in Target?

2 Answers

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers BirlaSoft,

What is the difference between lookup override and souce qualifier override ?

2 Answers Puma,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers Polaris, Zensar,

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

How does a rank transform differ from aggregator transform functions max and min?

0 Answers

For more Informatica Interview Questions Click Here