Can you pass sql queries in filter transformation?
what are the all possible features supported modify stage?
Explain the definition of normalized and denormalized view and what are the differences between them?
Why should we use data ware housing and how can you extract data for analysis with example?
What are cluster analysis in data warehousing?
What is difference macros and prompts?
Explain what is the extension of file to save template?
what are different types of partitioning in oracle ?
Explain the hierarchies level data warehousing.
Explain what is data validation strategies for data mart validation after loading process?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What are the fundamental elements of the data warehouse?
What is VLDB?