Where the data cube technology is used?
What are data modeling and data mining?
What is surrogate key? Explain with examples.
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is a real-time data warehouse?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
How do you define data block size?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are the possible data marts in retail sales?
What is informatica architecture?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
explain about balanced dimension,
Briefly state different between data ware house & data mart?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is static and local variable?