How can we transform row to column?
Explain how many ways you create ports?
Explain the different types of data warehousing?
Explain where do we use semi and non additive facts?
Suggest a good author for hyperion in data warehousing?
What is fact less fact table? Where you have used it in your project?
Explain when do we analyze the tables? How do we do it?
Where the cache files stored?
How to get the first 100 rows from the flat file into the target?
What is type 2 version dimension?
Explain bus schema?
What is surrogate key? Explain with examples.
Explain what is real time data-warehousing?