Informatica services stops automatically

Informatica Services are Getting Stop Automatically All of a sudden i couldn’t connect to Repository, I am getting an error. Usually this error comes if the Informatica service is not running. I tried to restart the service in services.msc but its not even starting. I tried many times but the result was same. My Repository… Continue reading Informatica services stops automatically

How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the same error from Source Qualifier Transformation while applying SQ properties. Let’s see how to fix this error. This is a part of ODBC Data Source configuration,… Continue reading How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

How to create source & target connections in session

How to create source & target connections in session If you are creating a session for the first time you mght not see any connections listed in the session properties. You need to add the connections in the workflow manager in order to show the list of connections in session level. Hope you have created… Continue reading How to create source & target connections in session

How to create connections in Oracle SQL developer

Create User & connections in Oracle SQL developer You should create at least one database user that you will use to create database objects. Here i created a database connection (ORACLEXE) for the SYSTEM user. Now I am going to create new users under SYSTEM connection. Here is the steps to follow … 1. Hope… Continue reading How to create connections in Oracle SQL developer

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points

TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points. Your session may fail with this error while doing aggregator transformation with ‘Sorted Input’ enabled. This is not a data Issue but a configuration Issue. We need to add a custom property (AggSupprtWithNoPartLic = YES) in the PowerCenter integration service to… Continue reading TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points

PCSF_46008 Cannot connect to domain to lookup service – Informatica power center

You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to below two possible scenarios.  Your informatica service is not running your database connection password might have expired    Here is the steps to follow to make sure… Continue reading PCSF_46008 Cannot connect to domain to lookup service – Informatica power center

How to unlock HR sample account in oracle 11G express edition

How to Unlock HR sample account in oracle 11G express edition This session will cover how to unlock HR sample account in oracle 11G express edition. Here is the steps to follow … 1. Go to CMD (Command Prompt) 2. Execute below commands in CMD 3. To connect to oracle database 11 G SQLPLUS / AS… Continue reading How to unlock HR sample account in oracle 11G express edition