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 |
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
Using Connected or unconnected lookup for performance wise which one is preferable?.
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Do you have to change the reject file b4 using reject loader utility.
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
if we have a delimiters at unwanted places in a flat file how can we over come those.
How many numbers of sessions can one group in batches?
What is deployemnt groups, Lables, query and dynamic deployment group.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the main difference between a Joiner Transformation and Union Transformation?
tell me 7.x and 8.x diferrencess(but not transformations)
What is update override?