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 Posted / 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 |
Post New Answer View All Answers
what is Active lock explain
Explain informatica architecture - version 8 / 9
What is Session and Batches?
How to load the data from people soft hrm to people soft erm using informatica?
How many numbers of sessions can one group in batches?
How can we store previous session logs?
What is decode in static cache?
How an expression transformation differs from aggregator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the benefit of partitioning a session?
Enlist some properties of sessions.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you set a varible in incremental aggregation