Introduction of the term critical column
Give a brief introduction of the term critical column?
Expert
A column (or usually granular) is named as critical column that altered the values over a era of time.
For illustration, there is a customer by name ‘Rick Ross’ who resided in New York for 5 years and moved to Brooklyn. Being in New York, he buys Rs. 30 Thousand Dollar worth of purchases. Now the change is the CITY in the data warehouse and the purchases now will shown in the city Brooklyn only. This type of procedure creates data warehouse incompatible. In this illustration, the CITY is the critical column. Surrogate key can be employed as a solution for this.
What is OLAP? Briefly define it.
Write down the unsupported repository objects for mapplet?
Explain different domain which is there in BO?
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
Explain the term Account and Directory options?
State the difference between the content store and content manager?
Describe briefly the term Session and Batches?
Explain in brief the term data warehouse.
What can be done with the Data Stage Director?
Give brief introduction of the term breakpoint in SSIS?
18,76,764
1939609 Asked
3,689
Active Tutors
1418204
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!