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 |
difference between stop and abort
What's the layout of parameter file (what does a parameter file contain?)?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What is staging area?
what are the differences between powercenter 8.1 and powercenter 8.5?
What is the function of look up transformation?
why we use datawarehouse
What is informatica powercenter repository?
How can we eliminate duplicate rows from flatfile,explain?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
How to load relational source into file target?
why union transformation is active transformation?