What is granularity? Please explain with example



What is granularity? Please explain with example..

Answer / 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

More ETL Interview Questions

What are the new features of informatica 9 version?

2 Answers  


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers  


Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


can cubes contain measures ?

0 Answers  






how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

0 Answers  


What are various etl tools in the market?

0 Answers  


what are business components in Informatica?

2 Answers  


What is full load & incremental or refresh load?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  


Categories