How to join 3 database like flat file, oracle, db2 in informatrica?
What Oracle features can be used to optimize my Warehouse system?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain degenerate dimension table?
DWH architecture?
What is Conceptual, Logical and Physical model?
What is execution plan?
What is a general purpose scheduling tool?
Explain what are conformed dimensions?
What is a cube in data warehousing concept?
What are the methodologies of data warehousing?
How can you implement many relations in star schema model?
Explain what are components of reportnet?