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 |
Explain different types of partitioning?
how would u estimate the size of Lookup transform data and index cache?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Is apache nifi an etl tool?
explain the methodology of Data Warehousing?(Polaries)
Explain about round-robi?
what are the facilities provided by OLAP to analytical users?
How many types of transformations supported by sorted input?
what is an ETL or ETT? And what are the different types?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?