Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
1982for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
2126Post New Data Warehouse General Questions
What is type 2 version dimension?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What are universe requirements?
Why denormalization is promoted in universe designing?
Explain a mapping, session, worklet, workflow, mapplet?
What are the possible data marts in retail sales?
What is a Decision Tree Algorithm?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Where the applications and where
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are data marts?
What is a general purpose scheduling tool?