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
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
without table how to come first record only in oracle?
How might one distinguish in the case of mapping is right or not without associating session?
How to update or delete the rows in a target, which do not have key fields?
What is the session task and command task?
How can we remove the duplicates from flat file source?
Briefly define a session task?
What is a grid in Informatica?
Briefly describe lookup transformation?
Explain the code page compatibility?
What are the measure objects?
How do you load unique records into one target table and duplicate records into a different target table?
What are the types of caches in lookup?
what is song in infrmatica...?
Explain scd type 3 through mapping.