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
difference between informatica 8.1.1 and 8.6
Mention few power centre client applications with their basic purpose?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is rank index in rank transformation?
Mention few advantages of router transformation over filter transformation.
What is the procedure for creating independent data marts from informatica 7.1?
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?
expain about the tune parameters?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the prerequisite tasks to achieve the session partition?
How to call shell scripts from informatica?
Global and Local shortcuts. Advantages.
what is mean by complex business rule ?
what is size of u r database?