Answer Posted / venkateshmalneni
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the use of transformation?
What is a sequence generator transformation?
Enlist few areas or real-time situations where informatica is required.
What does cheating measurement mean?
what is INFORMATICA TESTING process
Differentiate between sessions and batches?
lookup transformation with screenshots
On which transformations you created partitions in your project?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to create a non-reusable instance of reusable transformations?
what is the complex transformation you used in informatica
I have a flat file, want to reverse the contents of the flat file
Explain pushdown optimization $pushdownconfig parameter - informatica