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
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?
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?
What are the etl testing operations includes?
explain the methodology of Data Warehousing?(Polaries)
how many steps are there in etl process?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the data modeling tools you have used?(polaris)
what are the concerns of OLTP and DSS systems?
How many types of transformations supported by sorted input?
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?
State the differences between shortcut and reusable transformation
how to load the data to fact table?
when will use SQL override in a lookup transformation?
what is granularity in Data ware House?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.