why u go for dimensions ?
Answers were Sorted based on User's Feedback
Answer / purva
A set of level properties that describe a specific aspect
of a business, used for analyzing measures of one or more
levels.
With dimensions we can get a measurable quantity known as
facts . With this facts we can analyze the business levels
and helps in generating a report regarding the business.
Examples: geography, time, customer and product.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / jang
Generally for Analaysis, users use reporting tools.. like
Cognos,BO.rtc.... so here they can analysis a product or
item 's across varies regions, departments, vendors.....
Drill up and Drill down is possible with the help of Dimensions.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gp
What purva said is correct.
Analysis of data from different angles is called Dimension.
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the hint? how to use it to reduce the query processing in program?
How can informatica be used for an organization?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Suppose we do not group by on any ports of the aggregator what will be the output?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What does cheating measurement mean?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is the sequence generator transformation in informatica?
How to load last n records of file into target table - informatica
what is the architecture of any Data warehousing project?
Which files are created during the session rums by informatics server?
Where is metadata stored?