What is XMLA ?
How to improve session performance in aggregator transformation?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
How can we import and export using BCP utility?
What is execution plan?
Briefly state different between data ware house & data mart?
What is the difference between olap and oltp?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What are aggregate fact tables ? why they are needed? give an example
What are modeling tools available in the market?
What are algorithms provided by Microsoft in SQL Server?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
if source contain 10records how you identify header and footer