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

How to Register Salesforce plug-in in PowerCenter

How to Register Salesforce plug-in in PowerCenter

----------pmsfdc.xml

D:\Informatica\9.0.1\server\bin\native\pmsfdc.xml


ADMIN CONSOLE:-
STEP 1) Repository should be IN EXCLUSIVE MODE(CHANGE OPERTING MODE) THEN RESTART
STEP 2)GO TO BIN DIRECTORY. using command prompt(cmd)

STEP 3)USING PMREP COMMAND RUN BELOW COMMAND

pmrep connect -r PC_91(REPOSITORY_NAME) -d Domain_a(DOMAIN_NAME) -n Administrator -x Administrator

After successfully run :-

STEP 4)Register Plugin :-

pmrep registerplugin -i D:\Informatica\9.0.1\server\bin\native\pmsfdc.xml -e -N

-e -- For Update Existing Plugin
-N ---For Native Plugin

STEP 5) After Successfully registerd go to admin console.
   Change the operting mode EXCLUSIVE to NORMAL and then restart again.
 
STEP 6) Check wheather Salesforce plug-in registered or not:

go to:- Informatica Desiner :-About informatica desiner
 click on :- plug-in
 There is list of plugins

 check :-