In the PowerCenter Administration Console, set the following custom properties for the Integration Service Process JVMOption1 = -Xdebug JVMOption2 = -Xrunjdwp:transport=dt_socket,address=8300,server=y,suspend=n Complete the following steps to debug the java code of Java transformations in an Eclipse environment: In Eclipse, create a package named com.informatica.powercenter.server.jtx In Eclipse, create a class named JTXPartitionDriverImplGen In the PowerCenter Designer, copy the source code of the Java transformation you want to debug. To view the source code, go to the Java Code tab of the Java transformation and then select the full code option. Paste the source code into Eclipse. In Eclipse, create a Remote Java Application. To create a remote java application, select the class you created, click debug, right-click on Remote Java Application, and then choose New. Configure the host and port. Note: Configure the port number to be the same as the address parameter you defined in...
Informatica PowerCenter Repository tables I am sure every PowerCenter developer either has an intention or necessity to know about the Informatica metadata tables and where information is stored etc. For the starters, all the objects that we create in Informatica PowerCenter - let them be sources, targets, mappings, workflows, sessions, expressions, be it anything related to PowerCenter, will get stored in a set of database tables (call them as metadata tables or OPB tables or repository tables). * I want to know all the sessions in my folder that are calling some shell script/command in the Post-Session command task. * I want to know how many mappings have transformations that contain "STOCK_CODE" defined as a port. * I want to know all unused ports in my repository of 100 folders. In repositories where you have many number of sessions or workflows or mappings, it gets difficult to achieve this with the help of Informatica PowerCenter client tool...
This error may occur if the Java transformation does not find the JAR file. Follow the user guide from resources tab. Please try the below steps: Please make sure that the JAR file path should have a jar file name like “C:\Informatica\9.5.1\server\infa_shared\Temp\ concat.jar ”. For compile time: Under settings of Java Transformation, the first classpath should be an absolute path on the server and second should be the absolute path of the client machine. Make sure that file exists in both the locations. However, classpath of the server is optional. For run time: In session properties > Properties tab > Java Classpath > Here, provide the absolute path from server machine. If you still face the same problem, provide the path only from client machine twice.
Comments
Post a Comment