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 |
Mention some types of transformation?
What is fact table? Explain the different kinds of facts.
Under which circumstances, informatica server creates reject files?
what is difference between mapping and mapplet ?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
How to load only the first and last record of a flat file into the target?
Clarify the utilization of aggregator cache record?
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.,,
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Define Incremental Aggregation?
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.
How to load query faster,so that It will take less time to load?