ETL
Fact Table vs Dimension Table Comparison Table
Fact Table vs Dimension Table Comparison Table Characteristics Fact Table Dim…
Read more
Count Number of Male and Female from the city table using SQL
Count Number of Male and Female from the City Table using SQL Input ---------…
Read more
Informatica Scenario: Replacing Duplicate IDs (First 2 Char with XX)
Informatica Scenario: Replacing Duplicate IDs (First 2 Char with XX) SRC ----…
Read more
SQL
Informatica Scenario: Number of Vowels and Consonants in Name Field
Informatica Scenario: Number of Vowels and Consonants in Name Field In the Ex…
Read more
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 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