Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is facttable granularity?

Answer Posted / sri ram

The level of details to be stored in fact table is termed
as granularity.
Eg: for a Retail store, the granularity for sales fact is
as that of Point Of Sales i.e., each transaction occurs,
the data is stored in the fact table.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is informatica metadata?

1089


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2127


Which are the different editions of informatica powercenter that are available?

1080


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8296


Define sessions in informatica etl?

1101


What is meant by lookup transformation? Explain the types of lookup transformation?

1019


list out all the transformations which use cache?

1239


scenario where i can use only concurrent execution of workflow.

3258


As union transformation gives UNION ALL output, how you will get the UNION output?

1159


can u give example for factless fact table

6780


What is lookup transformation?

1093


What are the differences between oltp and olap?

1018


Separate from a database, an information bazaar, and an information stockroom?

1129


How to update source definition?

1141


Enlist the tasks for which source qualifier transformation is used.

1075