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 |
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
What you know about transaction control transformation?
how will compare two mappings in two different repository?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Is there any model difference between ODS and DWH
What is data transformation manager process?
How can you define a transformation? What are different types of transformations in Informatica?
What is repository manager?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?