Answered by Hemakumar on 2005-04-12 05:40:50: Cognos BusinessObjects MicroStrategies Actuate

Bharath

• Aug 27th, 2014

Pentaho Data Analytics

Ravi

• Aug 21st, 2014

IntelliView INEA
MS-Excel
Business Objects (Crystal Reports)
Cognos (Impromptu, Power Play)
Microstrategy
MS reporting services(SSRS)
Informatica Power Analyzer
Hyperion (BRIO)
Oracle Express OLAP
Proclarity
SAS
Qlikview
Actuate
jasper reports
Tableau

Answer Question  Select Best Answer

what is high level document(HLD),lowlevel document(LLD),MAPPING documents ? what is the stuff they contains?

Sarat

• Nov 13th, 2014

High Level Design document will prepare by the Data Modeling people to generate the required data warehouse schema for the ETL purpose. LLD : Low Level Design is the design document which will be use...

Answer Question  Select Best Answer

bryan

• Nov 17th, 2014

I dont see Boeings TwisterDataFramework. It is used extensively in the US Government and I thought it would be reviewed here.

Ashutosh Shukla

• May 4th, 2012

1. Oracle Warehouse Builder (OWB) 11gR1 Oracle 2. Data Services XI 3.2 SAP Business Objects 3. IBM Information Server (Datastage) 9.1 IBM 4. SAS Data Integration Studio 4.21 SAS Institute 5. Pow...

Answer Question  Select Best Answer

Monojit

• Dec 2nd, 2014

Kalido

hemant

• May 22nd, 2007

There is one more data modelling tool available in the market and that is "KALIDO".This is end to end data warehousing tool.?Its a unique and user friendly tool.

Answer Question  Select Best Answer

Ishu

• Feb 20th, 2015

SCD1: in SCD1, no history is maintained.
SCD2: whole history is maintained.
SCD3: just the current and last record is stored.

kalyan

• Nov 22nd, 2013

The value of dimensions is used change very rarely, That is called Slowly Changing dimensions.

they are 3 types

scd1
scd2
scd3

scd1:it used Replace the old values overwrite by new values
scd2:Creating Additional records
scd3:Its maintain just previous and recent

Answer Question  Select Best Answer

Santosh

• Jul 3rd, 2015

Datagaps ETL Validator has a lot of inbuilt features for ETL Testing automation. We are using it.

ora.amar

 Profile Answers by ora.amar Questions by ora.amar

• Aug 5th, 2014

We can use Data Validation option DVO provided by informatica corporation to automate etl testing.

Answer Question  Select Best Answer

What is push down optimization ? what is its use and importance in data warehousing ?

soundararajan

• Nov 1st, 2015

I need brief explaination about
* Source side pushdown optimization
* Target side pushdown optimization
* Full pushdown optimization

Sreedhar Lokaray

• Nov 3rd, 2011

Pushdown Optimization is a new feature introduced from Informatica 8. To increase session performance, the integration service pushes transformation logic to the source or target database. Based on t...

Answer Question  Select Best Answer

surrogate key is nothing but a primary key , but Does have any business meaning

avinash

• Apr 16th, 2016

Surrogate key is a key that is generated by a system and its has unique values.

Answer Question  Select Best Answer

EssamGad

• Apr 16th, 2016

No, Actually there is something called Rapidly Changing Dim or Fast Growing Dim, it is the Dim that contains an attribute that changes frequently. and one solution is to move this attribute to a new mini dim with a separate foreign key in the fact table.

dipanshu handoo

• May 26th, 2012

A dimension is considered to be a rapidly changing dimension if one or more of its attributes changes frequently in many rows. For a rapidly changing dimension, the dimension table can grow very large from the application of numerous Type 2 changes.

Answer Question  Select Best Answer

Answered by swetha on 2005-03-30 12:00:33: OLTP  Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery is necessary   OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...

ram

• Aug 30th, 2016

OLTP: Original Source of data
Running on fundamental business task

OLAP: Data coming from various OLTP sources
Problem Solving, Decision Making

Pravin

• Jan 16th, 2015

Very useful answer.
thanks.

Answer Question  Select Best Answer

TimeBeing

• Jan 25th, 2017

A Dimension table which is used by multiple Fact Tables is called "Confirmed Dimension".

matrixfree

• May 5th, 2016

Are the conformed dimensions the same as Common dimensions ? In Cognos Framework Manager ?

Answer Question  Select Best Answer

TimeBeing

• Jan 25th, 2017

Lookup for some related data in Database or Flatfiles or Database View based on key column

Johnson Weltch

• Dec 16th, 2016

This was great to know more about lookup table in database. You may also go through this informative article on look up table to get brief knowledge about Lookup table in database:
Lookup table in SQL Server at sqlmvp org

Answer Question  Select Best Answer

Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources. Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the...

chandrasekhar

• Mar 10th, 2017

The complete process of ETL activities (Extract, Transform and Load) and BI (Business Intelligence for generating reports) are called Data Warehousing.

TimeBeing

• Jan 25th, 2017

Datawarehousing is a process of Designing a database Schema, ETL process and Reporting.

Answer Question  Select Best Answer

vijay

• May 25th, 2017

While loading the data from Source to Target, if we are removing unwanted data or converting inconsistent data to consistent format is data clensing

TimeBeing

• Jan 25th, 2017

Data Cleansing is the process of converting inconsistent data into consistent data and removing unwanted data.

Answer Question  Select Best Answer

Kamlesh

• Jun 22nd, 2017

Yes dimension table can contain numeric value. i.e. Product dimension can have price, quantity as numeric values

uday

• Aug 17th, 2016

Yes, A dimension Table can have numeric data types and information. For example. the surrogate key columns which are numeric. and in a scenario if a product has min discount and max discount column...

Answer Question  Select Best Answer

praveen

• Jun 26th, 2017

how do you update when customer changed address: on 06-26-2016 -------------- 101,101_address1, on 06-26-2017, customer 101 moved to new loc and 102 added ---------------- 101,101_Address2 ...

TimeBeing

• Jan 25th, 2017

There are 2 types of data loading.
1. Initial Loading: Data loading for the first time in to Table/Database is called Initial Loading.

2. Incremental Loading: Inserting new data and updating existing data which comes with new values is Incremental Loading.

Answer Question  Select Best Answer

khalidmehmoodawan

• Jul 25th, 2017

These are different BI tools from different companies but doing the same task.

vempati

 Profile Answers by vempati Questions by vempati

• Mar 14th, 2007

BO is a ROLAP Tool,Cognos is a MLAP Tool and MicroStrategy is a HLAP Tool

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: saravanan

• Dec 2nd, 2005

---

Surrogate key is a unique identification key, it is like an artificial or alternative key to production key, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high

P.Manideep

• Oct 29th, 2017

Surrogate key is system generated key. It is a column or set of columns declared as primary key instead of real of natural key.

Anukul Thawarey

• Aug 8th, 2017

Just to add on to this point, we can also have date stamp as in the format (yyyymmdd) which is actually an 4 Byte unsigned integer to keep track of the historical data. This date stamp column can also be considered as an surrogate key.

Improve Answer

Naveed Akhtar

• Nov 4th, 2017

"Data Ware House" is a complete repository of historical corporate data extracted from transaction system that is available for ad-hoc access by knowledge workers, (Complete Repository) Means All dat...

Dr BK Verma

• Jul 2nd, 2017

Data Warehouse: It is just container to store the data from different sources. In this part we can't have right to analysis the data its just storage data. Data warehousing: If we use any intelligent...

Answer Question  Select Best Answer

John Deacutis

• Dec 26th, 2017

POS Transaction, not POS Transaction NUMBER, is the degenerated dimension.

q

• Jun 20th, 2017

Order number, invoice number, POS Transaction number, bill number. These are all examples of degenerate dimension table

Answer Question  Select Best Answer