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 different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

0 Answers  


What is factless fact schema?

3 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  


my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,


What is the difference between project backlog and product backlog?

0 Answers   IBM,


What is a mapping, session, worklet, workflow, mapplet?

0 Answers  


What is etl process? How many steps etl contains?

0 Answers  


Categories