Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is the difference between narmal load and bulk load?
Explain what is the metadata extension?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How can you set the session management?
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 meetthe condition.
if source contain 10records how you identify header and footer
How can we load the time dimension?
What is XMLA ?
Explain how to export mappings to the production environment?
what are the all possible features supported modify stage?
What is ods (operation data source)?