Tuesday, 22 November 2016

Linux Commands for Port Find and Blxok

To get the list of portnumber netstat -tulpn

To Free Port Number : sudo fuser -k Port_Number/tcp

Monday, 14 November 2016

Automated Trigger Creation for Insert Operations on Tables

Select Table_Name, 
'CREATE or REPLACE TRIGGER TRG_'||Table_Name||' AFTER INSERT ON '||'MODELREPO.'||Table_NAME||
' FOR EACH ROW DECLARE BEGIN INSERT INTO LOCAL.'||Table_Name||' Values('||
Listagg(':new.'||Column_Name,',') within group (order by column_id) || '); END;'||chr(10) ||'/' TRG_Creation

from all_tab_columns where owner='LOCAL'
and table_name in (Select table_name from tablelist where num_rows>1)
group by Table_Name order by 1 


​ 



Friday, 4 November 2016

Useful Commands for Informatica Data Quality:

Useful Commands for Informatica Data Quality(10.1.0) :

Locate the infacmd.sh file location and run the commands the from there:
1. List Services. 

./infacmd.sh isp ListServices -dn @DOMAINNAME -un admin -pd "@PASSWORD" -sdn Native -hp HOSTNAME:PORTNUM -re 60 -st AS 

2. Export Objects without Control File 

 ./infacmd.sh oie ExportObjects -dn @DOMAINNAME -un admin -pd "@PASSWORD" -sdn Native -pn PROJECTNAME -rs MRSNAME -fp /tmp/ashif/exp_TrialProj.xml

3. List Mapping of a Deployed Application 


./infacmd.sh MS listApplicationMappings -da infav10:6005 -sdn Native -un Admin -pd "@PASSWORD" -sn DataIntegrationServiceName -a App_Quality_Trans


4. Running the Profiling 

Using ExecuteProfile : 

./infacmd.sh ps executeProfile -dn infav10_Domain -hp infav10:6005 -nn infav10_Node01 -un Admin -pd "#ld@msf4" -sdn Native -msn infav10_ModelRepo_Service -dsn  infav10_Integ_Service -opn Custom_Solutions/Prof_Policy_Details

Using Execute: 

./infacmd.sh ps execute -dn infav10_Domain -hp infav10:6005 -nn infav10_Node01 -un Admin -pd "#ld@msf4" -sdn Native -msn infav10_ModelRepo_Service -dsn  infav10_Integ_Service -ot profile -opn Custom_Solutions/Prof_Policy_Details

5. Running the Scorecard

./infacmd.sh ps execute -dn infav10_Domain -hp infav10:6005 -nn infav10_Node01 -un Admin -pd "#ld@msf4" -sdn Native -msn infav10_ModelRepo_Service -dsn  infav10_Integ_Service -ot scorecard -opn Custom_Solutions/Scorecard_Policy_Details

Using Both Informatica Workflow Parameter File and Session Parameter File Together

The only way I know is to use a workflow parameter file and a session parameter file.

 

By default, when you define a workflow parameter file and a session parameter file for a session within the workflow, the Integration Service uses the workflow parameter file, and ignores the session parameter file.

 

You can force the workflow to use both the workflow parameter file and session parameter file by adding the following to the workflow section of the workflow parameter file:

 

    $PMMergeSessParamFile=TRUE

 

This must be set for the section defined for the workflow in the workflow parameter file.

 

Example

    [DEV_FOLDER.wf_workflow]

    $PMMergeSessParamFile=TRUE

 

Note

If you define the same parameter or variable in both the session and workflow parameter files, the Integration Service sets parameter and variable values according to the following rules:

 

  1. When a parameter or variable is defined in the same section of the workflow and session parameter files, the Integration Service uses the value in the workflow parameter file.
  2. When a parameter or variable is defined in both the session section of the session parameter file and the workflow section of the workflow parameter file, the Integration Service uses the value in the session parameter file.