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

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

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

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

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

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

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

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

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

Try to answer if you know

Anil

• Jul 25th, 2014

DWH helps you store the data while BI controls data for decision making, forcasting

Shrikanth

• Jun 12th, 2014

Data warehousing is a method to store the data in specially designed database. where as business intelligence processes the data in data warehouse to make some business decision.

Answer Question  Select Best Answer

Ankit Kansal

• Feb 15th, 2014

INFORMATICA is a data integration and warehousing tool which prepares data from different sources to a stream line flow after which a tool like OBIEE uses that data to display reports in several formats e.g. Charts & Graphs

Answer Question  Select Best Answer

Piyush Shah

• Feb 5th, 2014

One to many.

Answer Question  Select Best Answer

moluguri

 Profile Answers by moluguri Questions by moluguri

• Aug 30th, 2012

I think, we don't need separate space for Data Warehouse and Data Mart. Data Warehouse is a collection of Data Marts. Data Mart is a particular line of business..

Gvkishore

• Jan 16th, 2012

Why so.....Is there any advantage creating the DWH after creating the Datamarts...?

what is the use of Vice versa...?

Answer Question  Select Best Answer

kriti

• Jan 19th, 2012

OLTP: It stores current data.

ODS: It stores recent data

chetan singh tanwar

• Dec 22nd, 2011

OLTP: It is real time transaction. so all transaction comes in oltp, which are being perform at current time. ex- if we go to any showroom and buy anything then showroom owner creates our database and...

Answer Question  Select Best Answer

Hello Guys....please help...

I have an interview with NHS for a data ware house role and for which they have asked me to prepare a presentation on a topic "Describe how you would establish the operational (service) requirements for the data warehouse? I have 10 minutes for the presentation"

But I am a little confused with what i should put in the presentation. Please can anyone...

deokant

• Jan 18th, 2012

service requirement means establishing the connection between client and server...right? well if it is then i can guide you that how to connect a client machine to server via repository. once the ser...

Answer Question  Select Best Answer

Sreedhar Lokaray

• Nov 22nd, 2011

Could you please detail the question? Loading history is nothing to do with number of workflows. Might be you got confused between initial load and incremental load. A single workflow can be used for...

Ashwini Shetty

• Sep 18th, 2011

One work flow.....

Answer Question  Select Best Answer

Sreedhar Lokaray

• Nov 3rd, 2011

Business key is a primary key in the operational system. Surrogate key is a system generated primary key. In Dimensions and Facts we use Surrogate keys as Primary keys. Please refer my answer for the...

Ravi Teja N

• Sep 16th, 2011

Business Key is nothing but a natural key.Surrogate key is a system generator just like sequence in oracle.Basically we come across this in slowly changing dimensions type-II category.

Answer Question  Select Best Answer

what are homegeneous sorces and heterogeneous data sources ? Is flat file different from those two

Sreedhar Lokaray

• Nov 3rd, 2011

The dictionary meaning of Homogeneous is Uniform and Heterogeneous is Mixed. For example if a mapping is using only Oracle sources or Flat files or DB2 or XML or any other then they are called Homogen...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

ankeshjain  

 Profile Answers by ankeshjain Questions by ankeshjain

• Member Since Aug-2008 | Aug 17th, 2008

---

1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
 

Ravi Teja N

• Sep 16th, 2011

The steps used to develop a DWH are 1. Gathers Operational Source System 2. Data Staging Area 3. Data presentation Area 4. Data Access Tool Lets have a detailed information about each stage: Operat...

mohanbabu

• Aug 20th, 2011

We can create the dwh in two ways i.e
1. top down approach
2.bottom up approach

Improve Answer

RathiRam

 Profile Answers by RathiRam Questions by RathiRam

• Aug 24th, 2011

A logical design is conceptual and abstract. You do not deal with the physical implementation details yet. You deal only with defining the types of information that you need. Your logical design shoul...

Answer Question  Select Best Answer