Tutorial corner

Informatica,ETL,oracle,sql/plsql

Data warehouse

Data warehouse

Data Warehousing Concepts and key features

Data

Data warehousing is an integral part of any effective business intelligence endeavour which help in determine effectiveness of business processes, create policy, forecast trends, analyse the market and much more. In below tutorial , we will talk about Data Warehousing Concepts , its features and types. We will also talk about the architecture of Data warehouse . […]

slowly changing dimension type 6 with example | SCD6

SCD Type 6

slowly changing dimension type 6 : As we saw in last tutorial , Slowly Changing Dimension Type 2, tracks historical changes by  keeping multiple records for a given natural key in the dimensional tables. Slowly Changing Dimension Type 3 which keep history of some attribute in the same record itself .Slowly Changing Dimension is combination of SCD 1 + SCD […]

Copyright 2015 - Tutorial Corner Frontier Theme