SQL
Oracle SQL Query for fetching SUM of Quarterly Sales through order date
Oracle SQL Query for fetching SUM of Quarterly Sales through order date Oracl…
Read more
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 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