top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Java Transformation in Informatica

+3 votes

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

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

Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.