How do we do the Fact Load
What is the size of your Data warehouse?
What is your Daily feed size and weekly feed size
Answer / rameshreddy
After dimension load takes place we can load the Fact tables.
and
size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the difference between sequential batch and concurrent batch and which is recommended and why?
What happens if the info. Server doesn't find the session parameter in the parameter file?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
explain abt joiner t/r?
How can we use mapping variables in informatica? Where do we use them?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is the method of error handling when session is running?
wat are deployement groups in informatica, how it will be used for developers
what is the size of u r source(like file or table)?
What could be the possible resons of locks by user?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?