Interested to Buy Any Domain ? << Click Here >> for more details...
what are the facilities provided by OLAP to analytical users?
- 1 Answers
- 4637 Views
- I also Faced
- E-Mail Answers
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 are the different Reporting and ETL tools available in the market?
how do u implement unconn.stored proc. in a mapping?
what is SMP AND MPP?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain about the data integration suite features?
what is the meant by Normalization and de-normalization?
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?
Compare ETL & Manual development?
What are the types of Data Warehouse applications?
Is hadoop a etl tool?
Teradata 
