Thursday, June 25, 2015

encrypted password in Parameter File

  • On Windows, From command prompt go to folder bin of Server
     CD C:\Informatica\PowerCenter8.6.0\server\bin

  • Type following command where infotgt is password of target database
          pmpasswd infotgt -e CRYPT_DATA

  • Use the encrypted password in Parameter File
     [Dinesh.WF:wf_EMP_DEPT_SAL.ST:s_EMP_DEPT_SAL]
     $Param_tgt=rhDGQbmanvR2xgbbbfLw6A==

Friday, June 12, 2015

Informatica repository to search for column name exist in which mapping

select TO_OBJECT_FIELD_NAME,MAPPING_NAME from dbo.REP_MAPPING_CONN_PORTS
where TO_OBJECT_TYPE=2
AND SUBJECT_AREA='folder name'
and TO_OBJECT_FIELD_NAME ='column name'



SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name= 'column name'
ORDER BY schema_name, table_name;