I had applied for MSBI role so they had asked following . Types of FACT tables difference between multicast and conditional split scenario : how to give different previledges to different users who are going to logged into system Scenario : in the package which sequence you will follow out of below JOIN FILTER INDEX TRANSFORMATION