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

How to Refresh Parameter File On Run though Query

SELECT DISTINCT 
B.SUBJECT_AREA, 
B.TASK_NAME AS SES_WF_NAME, 
A.ATTR_VALUE AS PRM_FILE_PATH 
FROM 
OPB_TASK_ATTR A, 
REP_ALL_TASKS B 
WHERE 
A.ATTR_ID IN (1,4) 
AND A.TASK_ID = B.TASK_ID 
AND A.ATTR_VALUE LIKE '%.prm%' 
ORDER BY 1,2 ASC 

This query will give you all the sessions where your param being used, 
now once you get the access on Informatica repository get update the entries for old file by new one.