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:-

BigINT ISSUE in informatica

BIGINT issue in Informatica:-

Last few days ago i found  some discrepancy with using BIGINT in Informatica.
When i am going to convert any decimal value to bigint  its working fine ...
but issue is occurred to convert when having 0 is starting of any character.


Suppose 01234.0000 is source column and we need to convert it into bigint

Lets suppose wht do u think ....wht will be value...looks it .


01234

Firstly i thought it was 01234....but i got surprise when i debug  the ETL for perticular column.

it was 1234.  (Means 0 is removed)
so becareful before use of BIGINT  in informaTica