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 will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What is an aggregator transformation?
Can you copy the session to a different folder or repository?
when will we go for unconnected lookup transformation in Informatica?
how to calculate the optimum cache size in aggregator transformation?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
how to work with mapplet designer in informatica?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
How you count the number of records available at your source?
How are indexes created after completing the load process?