Mapping: Execute SQL Statements using JDBC

Mapping: Execute SQL Statements using JDBC

Posted by: Informatica Field

PowerCenter Java Transformation to read source data using JDBC connection

Overview

JDBC_Read_1.png
The PowerCenter ?Read? Java Transformation can be used when you need to read data from a database which only supports JDBC. This transformation has input ports for the JDBC connection itself (JDBC Driver Name, Connection Parameter, User, Password) as well as input ports for the SQL Statement that you want to pass to the database. If needed there are also input ports to pass parameters used i.e. in a where clause. Any valid SQL Statement that is supported by the JDBC driver can be passed to the transformation. The PowerCenter ?Read? Java Transformation for JDBC works a bit similarly to the PowerCenter SQL Transformation.

Features

  • This java transformation supports up to 30 columns as output ports, which are filled with the results of the SQL Statement (select * from). It is an active transformation, which can return several output rows for each incoming row.
  • There is a pass through port that can be used if needed, to pass through data, as the java transformation is an active transformation.
  • The PowerCenter Read Java Transformation does not cache data like a PowerCenter Lookup transformation. Each incoming row will send an SQL statement to the underlying database.
Informatica Product Requirements:
  • PowerCenter 8.6.x.
  • PowerCenter 9.x.

Resources

Support

Comments (3) Comment can only be posted by Signed/Logged in user

Sort: Newest | Oldest
  • Getting error while importing the workflow using repository manager:Error at (file \\GBMACCMPFS06\Daskaa$\Downloads\-I-Field-PC_Read_Java_Transformation\wf_m_Read_JDBC_Java_Tx.XML, line 136, char 160 ): Attribute 'INSTANCEID' is not declared for element 'INSTANCE'.Error encountered while Parsing fileMy informatica version is 9.0.1 Hotfix 2. Can someone assist here please or mail me kaushik.das@rbs.co.uk
     |   1
     Load replies
  • I am facing issues in setting this up, support people dont support it, can you please helpAnkit201-600-4744
  • This is very helpful to understand Java Transformation.
     |   1
     Load replies
Recommended Products