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
What are the advantages of informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to load data in informatica ?
Explain dynamic target flat file name generation in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
differences between service based and product based?
What are mapplets? How is it different from a Reusable Transformation?
What are the databases that informatica can connect to windows?
tell me the rules and responsblites in our project(my project is development)
Differentiate between joiner and lookup transformation?
Performance tuning( what you did in performance tuning)
What are the different transaction levels available in transaction control transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
can anyone explain me about retail domain project in informatica?
How does a rank transform differ from aggregator transform functions max and min?