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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What do you mean by filter transformation?
Briefly define reusable transformation?
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
How does the aggregator transformation handle null values?
How to join three sources using joiner?
How do you migrate data from one environment to another?
What could be the possible resons of locks by user?
What is a sorter transformation?
difference between repository database and repository service?
Explain the difference between mapping parameter and mapping variable?
What if the source is a flat-file?
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
How big was your fact table
What is a filter transformation?