Informatica

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

I remember that I heard the cloud concept about ten years ago while now the real cloud age is here. The cloud deployment and practice in CRM area might be the pioneer comparing with others. It is glad that we are seeing more and more BI vendors are boosting their cloud strategy and product development […]

The need to change the values actually being imported is inevitable when you are importing data into Salesforce. Scary to some, a matter of fact to most , but a way to shine for the users of Informatica . At Perficient we have been able to use the cloud tool Informatica which offers a wide […]

Perficient clients are able to leverage a wide range of tools across the broad spectrum of current technologies. Through the course of my experience with Perficient’s Salesforce team I have been able to help implement different types of technical solutions. My blog posts will focus in on various solutions, and I will start with the […]

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 […]

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, […]

  Scenario: Data source is a flat file and we want to load this data into the target. The problem is the source file name keeps on changing.  Here we go: Use a pre-session script that creates a file list. Windows dir /b part_of_file_name*.txt > FILELIST_NAME.LST UNIX ls part_of_file_name* > FILELIST_NAME.LST                 In Workflow Manager […]

A variable defined in a parameter file cannot be used in a post-session command alone. It must be used along with other session properties like Output file directory or Source file directory for it to be used in the post-session command.

A variable defined in a parameter file cannot be used in a post-session command alone. It must be used along with other session properties like Output file directory or Source file directory for it to be used in the post-session command. Example Consider a variable $OutputFileRepSybase that is defined as /home/test in the parameter file. If this variable is used in a post-session command alone, as […]

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.