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 |
If u r using dynamic cache lookup port will be thier in thet which option u will select
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain the different lookup methods used in informatica?
Design a mapping to load a target table with the following values from the above source?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What are the performance considerations when working with aggregator transformation?
How does a rank transform differ from aggregator transform functions max and min?
Label in Informatica. How to remove existing Label.
what is difference between dimention table and fact table?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Limitation of REPLACESTR. Is there any character limitation to it.