Troubleshooting
Fix Window display issues in the PowerCenter client tool
Description One of the windows (such as Navigator or Output) in a PowerCenter c…
Read more
SQL
How to Find Duplicate Values in SQL
Finding duplicates values in SQL comprises two key steps: Using the GROUP BY…
Read more
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 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 ...
-
How do you load unique records into one target table and duplicate records into a different target table? Source Table: COL1 COL2 COL3...
Social Plugin