Thursday, February 16, 2012

SSIS interview questions

 
1. Difference between control flow task and data flow task?
2. Ssis tasks
3. Common components between different packages
4. Where you will define parameters in ssrs?
5. Configurations in ssis?
6. Data ware house basic concepts ?

 7. What is fact less fact?
 Ans:Factless table means only the key available in the Fact there is no mesures availalable

A fact table which doesn't contains any facts  then called as fact less fact table.
generally when we need to merge two data marts one data mart will not have any facts and other one common fact of both usable.


 8.
 

No comments:

Post a Comment