what are the facilities provided by OLAP to analytical users?
Answer / maruthi
1.)MULTI-DIMENSIONAL ANALYSIS
2>)AD-HOC QURIES
3.)REDUCED REDUNDANCY
4.)AGGREGATED DATA
5.)SECURITY
| Is This Answer Correct ? | 1 Yes | 0 No |
What is etl tool in hadoop?
Explain about round-robi?
explain the methodology of Data Warehousing?(Polaries)
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is a mapping, session, worklet, workflow, mapplet?
what are the reporting tools and difference between them?
What are the modules in Power Mart?
how do u implement scheduling in Informatica?
Compare ETL & Manual development?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
dimension object created in oracle can be imported in designer?how?
WHY CANT WE SEE THE DATA IN DATASET