Explain which columns go to the fact table and which columns go the dimension table?
Explain what are the basic needs to join two sources in a source qualifier?
What is Discover and Execute in XMLA?
How can we import and export using BCP utility?
Explain how to get the first 100 rows from the flat file into the target?
What is data stream and data adaopter?
What is the difference between er modeling and dimensional modeling?
Explain the differences between normalizer and normalizer transformation?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
what is hybrid schema
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are the different types of join operations?
Briefly state different between data ware house & data mart?