what are the facilities provided by OLAP to analytical users?
- 1 Answers
- 4058 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 reports developed in sap bw project and what is the requirement for developing it?
Which transformation we use to convert 'NA' to 'Not Available'
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Do we need an ETL tool? When do we go for the tools in the market?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
How to Check the source record count from traget table.
what are business components in Informatica?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
what is SMP AND MPP?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Teradata 
