top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Java Transformation in Informatica

+3 votes
456 views

Can I write sql queries in Java transformation? Is there any possibilities?

I need to do query like this

String ID = select id from tablename where name='XXXX'.
posted Oct 27, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You should be able to use JDBC libraries with in Java transformation. You can download sample mapping demonstrating this functionality from Informatica Marketplace App

https://community.informatica.com/solutions/mapping_jdbc_read_java_transformation

answer Oct 30, 2014 by Shweta Singh
Similar Questions
+3 votes

How do I access a mapping parameter ($$myvariable) from a Java Transformation in Informatica Powercenter?

What I want to do is to make a Java transformation reusable by making a part of it configurable, and a variable seemed suitable for that, however I haven't been able to access (read) a variable from the Java code.

+2 votes

If both source have same rows, same number of columns and no duplicate which one should be choosen to be master in joiner trasnformation

...