What is a custom dimension?

How can we remove duplicates from fact table?

How to get rejected data from the join stage without using any stages after join?

What is Dynamic Insert?

mkm187

 Profile Answers by mkm187 Questions by mkm187

• Oct 5th, 2010

INSERT FIRSTWHEN SAL > 25000 THENINTO special_sal VALUES(DEPTID, SAL)WHEN HIREDATE like ('%00%') THENINTO hiredate_history_00 VALUES(DEPTID,HIREDATE)WHEN HIREDATE like ('%99%') THEN...

Answer Question  Select Best Answer

How is SCD helpful in real time? Give example by taking banking project.

rummyraj

 Profile Answers by rummyraj Questions by rummyraj

• Oct 13th, 2010

Customer dimension is a good example. Customer address and Phone number frequently changes. So you will update the customer dimension for these changes.Hence its called as SCD. There are several types though. This example is type1 SCD.

Answer Question  Select Best Answer

What are the prioritized Rules in Transform function?

What are the different tracing options available? Can tracing options be set for individual transformations?

joshmohit

 Profile Answers by joshmohit Questions by joshmohit

• Nov 3rd, 2010

I am not sure if this pertains to the datawarehouse in general but we do have concept of audit dimensions. Also, dimensions with effective dating can help tracing the changes.

sraghav20

 Profile Answers by sraghav20 Questions by sraghav20

• Oct 7th, 2010

I guess, this question should be directed towards particular tools... as a concept, data warehousing would be hard pressed to have any logging...

Answer Question  Select Best Answer

What is the Central Repository? Is it possible to login from designer?

joanitah

 Profile Answers by joanitah Questions by joanitah

• Mar 12th, 2011

This is a process and outcomes of modeling a logical database schemas created to support OLAP and data warehousing solutions.

Hakoonamatata

 Profile Answers by Hakoonamatata Questions by Hakoonamatata

• Jul 9th, 2007

Here's a different way to look at dimensional modelling:Consider data to be a flat table for now. It would have some columns that contain numbers that need to be used in calcualtions later (e.g. b...

Answer Question  Select Best Answer

What is the use of Degenerated dimension? Where it is used?

gargupendar

 Profile Answers by gargupendar Questions by gargupendar

• Mar 24th, 2011

A degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.Example : Receipt number is the perfect example for degenerate dimension.

Answer Question  Select Best Answer

How anyone define the pracical difference between Kimball & Inmon?

Read Best Answer

Editorial / Best Answer

shashk  

 Profile Answers by shashk Questions by shashk

• Member Since Jul-2010 | Aug 25th, 2010

---

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.

Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.

There is no right or wrong between these two ideas, as they represent different data warehousing philosophies.
In reality, the data warehouse in most enterprises are closer to Ralph Kimball's idea. This is because most data warehouses started out as a departmental effort, and hence they originated as a data mart. Only when more data marts are built later do they evolve into a data warehouse.

shashk

 Profile Answers by shashk Questions by shashk

• Aug 25th, 2010

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse...

Improve Answer

When do we use Degenerated Dimension?

pradeep reddy gade

• Jul 21st, 2011

Any values in the fact table that dont join to dimensions are either considered degenerate dimensions or measures

Answer Question  Select Best Answer

How to partition a cube in analysis services?

Rambabu Kola

• Sep 7th, 2011

-->create cube using ssas and deploy it.
-->connect sql server management studio
-->then connect sql server analysing services
-->right click on cube and click partition
----------------------------------------------------------------
like this we can partition the cube..

Answer Question  Select Best Answer

surender.Vanga

• Sep 18th, 2011

Here are some questions... (I am assuming that you are asking about Informatica data quality) 1. What are the most used transformations in IDQ? 2. What is address doctor? 3. Can we export an object fr...

ravi_kumar_garre

• Nov 11th, 2007

Interview questions for Data Quality Analyst are as follows:1. How can you say there are no duplicate records in Data warehouse?2. Whether the ETL job accepts known accept records?3. What are the Data Quality Tools? e.g. BO Data Quality, First Logic..etc

Answer Question  Select Best Answer

What is the difference between replicate and broadcast ?

chandana

• Sep 21st, 2011

Replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.

zann1

 Profile Answers by zann1 Questions by zann1

• Sep 7th, 2009

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usuall...

Answer Question  Select Best Answer

What difference between dimension and hierarchy>What is mean by maxl?difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?

Sahil

• Oct 25th, 2011

Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,

karna.siva

 Profile Answers by karna.siva Questions by karna.siva

• May 20th, 2008

A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc.  and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...

Answer Question  Select Best Answer

How to pass first, Middle and last record in flat file to flat file?

KVR Prasad

• Dec 1st, 2011

By using sequence generator, Expression transformation and router T/R it will be possible.

Answer Question  Select Best Answer

Rajesh Swarnkar

• Feb 28th, 2012

Data Marts are considered as smaller logical subset of Data warehouse. DW is enterprise-wide while DMs are for Department Level. So DMs can be identified on the basis of what departments are there in Insurance company.
E.g. Sales Department.

Answer Question  Select Best Answer

Why do we use Surrogate Key?

Rajesh Swarnkar

• Feb 28th, 2012

Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.

sadique_ghitm

 Profile Answers by sadique_ghitm Questions by sadique_ghitm

• Nov 25th, 2011

A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...

Answer Question  Select Best Answer

How can you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data

Iftikhar Alam

• Apr 8th, 2012

Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called Demoralized but it is normalized not like the transactional

madhavig

 Profile Answers by madhavig Questions by madhavig

• Feb 16th, 2010

Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.Dimensions are de-normalized for better query performance and for better understanding by business users.

Answer Question  Select Best Answer