why u go for dimensions ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the transformations that are not supported in mapplet?

602


What are the differences between oltp and olap?

553


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


What is a repository? And how to add it in an informatica client?

663


What is dynamic cache?

614






I have a flat file, want to reverse the contents of the flat file

698


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1629


can anyone suggest best free Talend data integration training online

1263


How to extract sap data using informatica? What is abap? What are idocs?

560


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


difference between repository database and repository service?

626


Explain your project of banking domian.

1220


Explain what is informatica metadata and where is it stored?

613


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

606


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

774