What are cubes and olap cubes?
Answer / Devendra Kumar Gupta
A cube is a multidimensional database structure used in Online Analytical Processing (OLAP). An OLAP cube is a collection of facts and dimensions, organized in a way that enables fast querying and complex analysis.nCubes allow users to perform operations like slicing, dicing, drilling, pivoting, and rolling up or down data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What exact we can see in table?
What is partitioning? Explain about round-robin, hash partitioning.
what is Forward,Reverse and Re_engineering?
What are the ETL Testing Operations?
how do u set partition points in the mapping?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Define slowly changing dimensions (SCD)?
can be used COM component in Informatica ?
How many steps etl contains?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.