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
what is informatica metadata?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Which are the different editions of informatica powercenter that are available?
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
Define sessions in informatica etl?
What is meant by lookup transformation? Explain the types of lookup transformation?
list out all the transformations which use cache?
scenario where i can use only concurrent execution of workflow.
As union transformation gives UNION ALL output, how you will get the UNION output?
can u give example for factless fact table
What is lookup transformation?
What are the differences between oltp and olap?
Separate from a database, an information bazaar, and an information stockroom?
How to update source definition?
Enlist the tasks for which source qualifier transformation is used.