why u go for dimensions ?

Answers were Sorted based on User's Feedback



why u go for dimensions ?..

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

why u go for dimensions ?..

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

why u go for dimensions ?..

Answer / gp

What purva said is correct.

Analysis of data from different angles is called Dimension.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

Mention some types of transformation?

0 Answers  


What is fact table? Explain the different kinds of facts.

0 Answers  


Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


what is difference between mapping and mapplet ?

2 Answers   TCS,


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  






How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,


Clarify the utilization of aggregator cache record?

0 Answers  


case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


Define Incremental Aggregation?

2 Answers  


Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,


How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,


Categories