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

difference between informatica 8.1.1 and 8.6

3349


Mention few power centre client applications with their basic purpose?

619


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

816


What is rank index in rank transformation?

690


Mention few advantages of router transformation over filter transformation.

738






What is the procedure for creating independent data marts from informatica 7.1?

669


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

881


expain about the tune parameters?

2006


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1162


Can we change Dynamic to Static or Persistent cache? If so what happens?

1810


What are the prerequisite tasks to achieve the session partition?

811


How to call shell scripts from informatica?

662


Global and Local shortcuts. Advantages.

1565


what is mean by complex business rule ?

1800


what is size of u r database?

1941