SQL ,Data Warehouse and Testing Concepts

When dimension changes over a period of time, it is called as Slowly Changing Dimension and it is very popularly known as SCD. It is used f...

Data Validation in Data Warehouse has always been challenging. One of the most frequently way of data validation is by using MINUS/ EXCEPT...

SCENARIO:    We have EMP_DETAILS table which contains employee details such as EMPID, GENDER,EMAILID and DEPT_ID columns. We want to d...

When we are working on ORACLE SQL DEVELOPER, we come across many situations where we need to copy only column names of a table or column na...