What is granularity? Please explain with example
Answer Posted / lakshmi
Granularity defines the extent of details
Example:Let us look at geographical level of granularity.We may analyze data at the levels of country,region,territory,city and street.In this case,highest level of granularity is street.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List few etl bugs?
what are the production issues in datastage?
what is data modeling?
Can u access a repository created in previous version of Informatica?
SCD2 will work on only dimension tables as well as fact Table?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
Explain etl mapping sheets?
What is staging area referring to?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is data modeling?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What are the various tools used in etl?
how do u really know that paging to disk is happening while u are using a lookup transform?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?