Showing posts with the label Data WarehouseShow all
ETL
Fact Table vs Dimension Table Comparison Table
Fact Table vs Dimension Table Comparison Table Characteristics Fact Table Dim…
Read more
Data Warehouse
What is Fact Table?
What is a Fact Table? The Measureable event for the reference information is s…
Read more
IICS
HOW TO: Implement SCD Type-2 using Dynamic Lookup in Informatica Cloud (IICS)
Introduction A Slowly Changing Dimension (SCD) is a dimension that stores and…
Read more
IICS
HOW TO: Implement SCD Type-2 Mapping in Informatica Cloud (IICS)
What is Slowly Changing Dimension (SCD) Type-2? A Slowly Changing Dimension T…
Read more
IICS
HOW TO: Implement SCD Type-1 Mapping in Informatica Cloud (IICS)
HOW TO: Implement SCD Type-1 Mapping in Informatica Cloud (IICS) What is Slow…
Read morePopular Posts
-
Sending Odd-numbered records to one target and even-numbered records to another target OR How to send the alternate record to the target...
-
Retrieving the first and last record from a table/file Source Table: OT_SRC_DEV1.Employees . . . . . . Step 1: Drag the Source on Source ...
-
The primary key identifies each record in the table, and the unique key prevents duplicate entries in a column except for a NULL value.
Social Plugin