Informatica
How do you load unique records into one target table and duplicate records into a different target table?
How do you load unique records into one target table and duplicate records in…
Read more
Data Warehouse
What is Fact Table?
What is a Fact Table? The Measureable event for the reference information is s…
Read more
SQL
How to find Table Size in Oracle
Below are the important query to check table size of partition and non part…
Read more
What is Dimension Model / Table?
What is Dimension Model / Table? In Data Warehouse, a dimension is a collectio…
Read more
ETL
What is the difference between a data warehouse and a data mart?
What is the difference between a data warehouse and a data mart? Here is the m…
Read more
Informatica
Retrieving first and last record from a table/file
Retrieving the first and last record from a table/file Source Table: OT_SRC_D…
Read more
Informatica
Sending Odd numbered records to one target and even numbered records to another target | How to send alternate record to target?
Sending Odd-numbered records to one target and even-numbered records to anoth…
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