Translate to your Language

Disclaimer Statement

Total Pageviews

Track

Follow us on FaceBook

About

Powered by Blogger.

Blog Archive

Popular Posts

  • Netezza ISNUMERIC Data Check Logic
    Netezza dosen't have any isnumeric check function, so in order to find out whether the column has non-numeric, use the following logic n...
  • How to do PIVOT in netezza SQL
    If you have table like below GROUP_NAME  GROUP_ID    PASS_FAIL   COUNT     GROUP1        5            FAIL     382     GROUP...
  • Datastage DSX Files Export Script
    @echo off :: ----------------------------------------------------------------- :: DataStageExport.bat :: -----------------------------------...
  • Netezza Optimizer Parameters
    Netezza has 3 internal planner • Fact Relationship Planner (factrel_planner) • Snowflake Planner • Star Planner In the course of a query pla...
  • Big Data and Hadoop Questions and Answers
    What is Big Data? Big data is data that exceeds the processing capacity of traditional database systems. The data is too big, moves too fast...
  • Informatica Job Interview Question & Answers
    Source :-dwh-ejtl.blogspot.com Q1) Tell me what exactly, what was your role? A1) I worked as ETL Developer. I was also involved in requireme...
  • What is ETL Mapping Document ?A Real Time Example
    One of the regular viewer of this blog requested me to explain the important's of the ETL mapping document. What is ETL Mapping Document...
  • NOSQL 101
    I am sure most of you heard about market buzz words nosql,newsql... and it often make our DW developers to get confused on this new terms.Mo...
  • Conformed Dimensions with example
    In data warehousing, a conformed dimension is a   dimension   that has the same meaning to every fact table in the structure. Conformed dim...
  • Data Generation Using DataStage
    This note assumes some familiarity with the DataStage transformation engine. DataStage is normally used to process multiple input files and/...

Thursday, December 27, 2012

Conformed Dimensions with example

by Unknown  |  in DW at  1:04 AM


In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact table in the structure. Conformed dimensions allow facts and its measures to be accessed in the same way across multiple facts, ensuring consistent reporting across the enterprise.
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts.  


As you can see in the above figure,the time and cust dimensions are called confirmed dimensions as they are shared across multiple fact tables with the same meaning.


2 comments:

  1. cloverOctober 28, 2013 at 11:35 PM

    Spotted your write – ups, it’s cool. Very beneficial and interesting there are some ideas I haven’t heard before. Thanks for sharing.

    clover
    www.n8fan.net

    ReplyDelete
  2. eddyshaw9272711June 19, 2018 at 1:05 AM

    I’d need to test with you here. Which is not one thing I usually do! I take pleasure in reading a submit that may make people think. Additionally, thanks for allowing me to comment! online casino games

    ReplyDelete

© Copyright © 2014Bigdata-dwbi. by