Answer Posted / sri ram
The level of details to be stored in fact table is termed
as granularity.
Eg: for a Retail store, the granularity for sales fact is
as that of Point Of Sales i.e., each transaction occurs,
the data is stored in the fact table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is a snowflake schema?
What are the new features of informatica 9.x developer?
What does refresh system mean, and what are its distinctive choice?
What is primary and backup node?
What are the tuning techniques you applied during your last project
What are the new features of informatica 9.x in developer level?
how many types of dimensions are available in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the tasks that source qualifier perform?
r u done any partitions in ur project?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you understand by term role-playing dimension?
What is rank transformation?
What is a filter transformation and why it is an active one?