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
How do you update the records with or without using update strategy?
What is powercenter on grid?
what is the hint? how to use it to reduce the query processing in program?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
pmscmd startworkflow -sv
Explain the types of transformations?
What are the measure objects?
what is the Default Source Option For Update Strategy Transformation?
How to convert multiple rows to single row (multiple columns) in informatica
server hot-ws270 is connect to Repository B. What does it mean?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How is union transformation utilized?
what is degenerated dimension?
differences between service based and product based?
What is a sequence generator transformation?