Can we start and stop single session in concurent bstch?
How to get the first 100 rows from the flat file into the target?
Explain the difference between filter and conditin?
What are fact, dimension, and measure?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are the approaches used by optimizer during execution plan?
What are the various tools? Explain name a few?
what is difference between drill & scope of analysis?
What is incremintal loading?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is your spectra photometer working principles?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Why is chameleon method used in data warehouse?
What is the definition of cube in datawarehousing?
How to improve session performance in aggregator transformation?