What is Staging area why we need it in DWH?
If target and source databases are different and target table volume is high it contains some millions of records in this scenario, if we create staging tables in the target database we can simply do outer join in the to…
There are three levels of data modeling. They are conceptual, logical, and physical.
Logical Data Model
Physical Data Model
Fact and Dimensions..
What is Fact Table?
A Fact table in a data warehousing data model consists of one or more numeric facts of importance for a business .Facts must be consistent with the granularity.
1. Number of service call received.
2. Amount of sales collection.
Data warehouse Schemas and it’s type..
What is Schema?
Graphical representation of the data structures . It is the first phase of the implementation cycle.
What is a star schema?
Star schema is a data warehouse schema where there is only one “fact table” and many de-normalized dimension tables.
Data warehouse is a collection of data from multiple systems into one single platform with common data formats which supports strategic decision making for business at enterprise level.
It comprises of few important properties:
Data that gives information about a particular subject instead of about a company’s ongoing operations…
Let’s learn step-by-step approach to handle DDL changes of already existing HVR channel table.
HVR Provides Adapt DDL option to handle table DDL changes on the fly automatically. But, this option is risky and one should not use in channel definition.
Here are reason why Adapt DDL option is not…
I am using HVR for a while now and I do see a lot of potential of HVR tool in data replication business segment. I have used other replication tools but the interesting part about HVR is it is actually a very simple and easy to use tool.
A One Stop Solution for most of your Snowflake Usage and Security Problems.
Snowflake Account Usage views are great when it comes to understand overall usage of snowflake account and to create advance usage analytics dashboards to address the right usage of this savage platform in a right way. …
Head Quarters : San Francisco| Founded : 2012|Tech : Change Data Capture
An amazing solution to replicate data across system in real time.
A Log based CDC tool with its unique ways to handle SCD and Transactional changes of source system to target with super low impact to both source…