Skip to main content

Linda Lin

Blogs from this Author

Informatica: Money Data Type Doesn’t Get Accurate Value in Target

Problem Description: Several days ago when I ran a PowerCenter session, I encountered an issue of populating column value of money data type from one Microsoft SQL Server table to another. For example, the original source value is 1234.1250, but after I loaded it to another table, it became 1234.1136. In Informatica, the column data […]

Informatica: How to Set a Target Flat File Name with Timestamp

Scenario We want to create a target flat file name with the current system date. Solution 1 The first method is renaming the target file name in the post session command as bellow: Example: The following command will rename the file in the format filename_MMDDYYYY.out in Windows: move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out

SQL SERVER – Introduction to LEAD and LAG

SQL Server 2012 introduces new analytical functions LEAD () and LAG (). These functions accesses data from subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join. The syntax for the Lead and Lag functions is: Note that: −        “Partition by clause” is optional, “order […]

Informatica: Removing Duplicate Source Records

Duplicate records are occasionally found in source data. Due to primary key constraints on a target database, only one version of a duplicate source record should be loaded into the target. The following methods demonstrate some of the most efficient ways to deal with duplicate source data. 1. Aggregator Transformation When to use Any time […]

Informatica: Target Update Override

Target update override is also like source qualifier override. It is useful to update the target without using the update strategy transformation. You can find the Target Update Override option in the target definition properties tab. The syntax of update statement to be specified in Target Update Override is UDATE TARGET_TABLE_NAME SET TARGET_COLUMN1 = :TU.TARGET_PORT1, […]

Combine Rows with FOR XML PATH

We can use FOR XML PATH to combine rows.  For example, have the following data:   And I want to combine the value of column SRC_ID_SEED from all rows to a single row as:   We can achieve this by using FOR XML PATH(): select stuff((select ‘,’+cast(src_id_seed as varchar(20))          from DATA_SOURCES          FOR XML PATH ( […]

Informatica:Use a Microsoft Excel worksheet as a source

Step 1. Create and configure the Excel worksheet. In Microsoft Excel do the following: Select the required rows to be read into PowerCenter. Select Insert > Name > Define (Formulas > Name Manager in Excel 2007). Enter a name for the range. Click OK. Save the worksheet.

How to use different charts in reports

After read chapter 1 of book《Head First Statistics》, I found there are some good points about how to use different charts in reports. So I summarized below to share with everyone. 1. Pie charts are used to compare the proportions of different groups or categories. It’s usually easy to tell at a glance which groups […]