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


Please Help Members By Posting Answers For Below Questions

what is Active lock explain

2369


Explain informatica architecture - version 8 / 9

669


What is Session and Batches?

664


How to load the data from people soft hrm to people soft erm using informatica?

560


How many numbers of sessions can one group in batches?

619






How can we store previous session logs?

567


What is decode in static cache?

590


How an expression transformation differs from aggregator transformation?

626


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1838


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

605


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7675


What is the benefit of partitioning a session?

625


Enlist some properties of sessions.

626


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.

1850


How do you set a varible in incremental aggregation

1444