Informatica Powercenter Architecture Kareem Friday, August 31, 2012 Informatica Software Architecture illustrated as : Informatica ETL product, known as Informatica Power Center consists of 3 main compone... Read More
Informatica Project Kareem Friday, August 31, 2012 DWH Bank Project Explanation First you have to start with Objective of the project and what are clien... Read More
Convert Numeric Value to Date Format Kareem Thursday, August 23, 2012 Suppose you are importing a flat file emp.csv and hire_date column is in numeric format, like 20101111 . Our objective is convert it t... Read More
Currency converter - Informatica mappings Kareem Thursday, August 23, 2012 Suppose that a source contains a column which holds the salary information prefixed with the currency code, for example EMPNO ... Read More
Date Difference in Hours Kareem Thursday, August 23, 2012 Scenario: There is A ORDER_DELIVERY table having record like this ORDER_NO ORDER_DATE DELIVERY_DATE ... Read More
How do we perform incremental logic or Delta or CDC? Kareem Thursday, August 23, 2012 Incremental means suppose today we processed 100 records, for tomorrow run u need to extract whatever the records inserted newly and upd... Read More
Separate rows on group basis Kareem Thursday, August 23, 2012 In Dept table there are four departments (dept no 40,30,20,10). Separate the record to different target department wise. Solution : S... Read More
Get top 5 records to target without using rank Kareem Thursday, August 23, 2012 How to get top 5 records to target without using rank ? Solution: Drag the source to mapping and connect it to sorter transformat... Read More