Using source to read from multiple flat files where structure is same

Using source to read from multiple flat files where structure is same

https://nigamankur.wordpress.com/2011/08/25/using-file-list-as-source-to-read-from-multiple-flat-files/

How to generate target file names dynamically from the mapping with timestamps

How to generate target file names dynamically from the mapping with timestamps

When you want to create the file name with a timestamp attached to it, just use a port from an Expression transformation before the target to pass a value of Output Port with expression $$FILE_NAMEto_char(sessstarttime, 'YYYYMMDDHH24:MISS')'.csv'.

How can we store previous session logs in informatica

How can we store previous session logs in informatica

Go to Session Properties –> Config Object –> Log Options

Select the properties as follows….

Save session log by –> SessionRuns

Save session log for these runs –> Change the number that you want to save the number of log files (Default is 0)

If you want to save all of the logfiles created by every run, and then select the option Save session log for these runs –> Session TimeStamp

You can find these properties in the session/workflow Properties

Insert records in 2 diff tables

Insert records in 2 diff tables

JAVA TRANSFORMATION Delete condition records from any source

JAVA TRANSFORMATION  Delete condition records from any source

Here  all rows which is satisfied by given condition is not loaded into target table .
        if(Commission<=10)

Getting Previous Row Value Informatica

Getting Previous Row Value Informatica

Enjoyee:)

HOW TO CONVERT ROW TO COLUMN IN IN INFORMATICA USING AGGREGATOR

HOW TO CONVERT ROW TO COLUMN IN IN INFORMATICA USING AGGREGATOR

STEP 1:-

STEP2:-