What Oracle tools can be used to design and build a W/H?
How to design file watch jobs?
Can decision tree be implemented using SQL?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are data modeling and data mining?
Explain what is the extension of file to save template?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Is there any difference in testing database and data ware housing?
What is degenerate dimension table?
What are the fundamental elements of the data warehouse?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain what is real time data-warehousing?
if source contain 10records how you identify header and footer