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
Explain about enterprise scalability and roi of data integration suite?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are your responsibilities as an etl tester?
what is different between sequential batch and concurrent batch and which is recommended and why?
how many steps are there in etl process?
Which transformation we use to convert 'NA' to 'Not Available'
When do we analyze the tables? How do we do it?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what are the concerns of OLTP and DSS systems?
what is the use of server?
What is full load & incremental or refresh load?
Give the benefits of data integration suite?
when will use SQL override in a lookup transformation?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture