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

Explain where to store informatica rejected data? How to extract the informatica rejected data?

582


What do you mean by filter transformation?

557


Briefly define reusable transformation?

625


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1655


How does the aggregator transformation handle null values?

701






How to join three sources using joiner?

575


How do you migrate data from one environment to another?

647


What could be the possible resons of locks by user?

665


What is a sorter transformation?

663


difference between repository database and repository service?

626


Explain the difference between mapping parameter and mapping variable?

606


What if the source is a flat-file?

594


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4314


How big was your fact table

1320


What is a filter transformation?

571