top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Java Transformation in Informatica

+3 votes
397 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
informatica-powercenter Mapping variable in Java

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
Unique Joiner Transformation in Informatica?

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

...