February 7, 2017
Fact Data

All you need to know about Facts and Types of Facts.

Lets start with the word called ‘granularity’ or ‘the grain’ first and then we understand the Fact. Later we will proceed with the types of Facts. […]
February 1, 2017
Data Load Strategy

What is data load strategy for testing? How to perform it? and How to test full load and incremental load?

What is the Data Load Strategy? Depending on the phase in which you take this up the answer will vary. For example, if you are looking […]
January 31, 2017
database Schema

Which table should be loaded first? Fact or Dimensions?

Let’s understand this with an example.. If you have sales fact table which is loaded first with a record with a sale of $5000. You are curious […]
January 27, 2017

If update override option is already in tgt instance why do we need upd strategy?

Update Strategy works only when you have primary key defined in the target table/ definition and when you want to update the target table based on […]