top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to add an intermediate calculated “variable” in informatica

+2 votes
89 views

I am making a flow like:

(Source A - Source A Qualifier) and (Source B - Source B Qualifier) -> Joiner -> Target

Say I need to calculate a a variable/column over Source A in order to join Source A and Source B.

Can anyone please help me how to do that?

posted Mar 25, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

You can use an Expression transformation to calculate the value required. This would be placed between Source A and the joiner, with an output only port added with the logic inside.

However, if the calculation is simple enough, you can have it pre-computed in the SQL query for Source A. This is advantageous as it will allow you to sort both sources on the common column(s) and use the Sorted Input option on the Joiner, which performs much better.

answer Mar 25, 2014 by Shweta Singh
Similar Questions
+2 votes

I am an Informatica newbie, and making a flow like:

(Source A - Source A Qualifier) and (Source B - Source B Qualifier) -> Joiner -> Target

say I need to calculate a a variable/column over Source A in order to join Source A and Source B.

Can you please help me how to do that?

0 votes

I have Informatica 9 and an Oracle database in my system. Now I want to install a SQL Server database in my system and add this database to Informatica.

Is that possible ?

Purpose: I need to migrate some of the tables from SQL Server to Oracle database using informatica.

Could anyone let me know, after installing SQL Server, how can I add this SQL Server database to informatica for creating mapping?

+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.

0 votes

I need to add a variable inside an array of an embedding gravity forms to populate 2 hidden fields: email and jobname.

Here is my code:

<?php 

    $email = get_field( "email_application" );
    $jobtitle = get_the_title();

    gravity_form( 5, false, false, false, array('email'=>'echo "$email";','jobname'=>'print "$jobtitle";'), false); 
?>

I know that echo, print or just the variable doesn't work as it show like this in my code:

<input name="input_6" id="input_5_6" type="hidden" value="print $jobtitle" class="gform_hidden" aria-invalid="false">

and

<input name="input_5" id="input_5_5" type="hidden" value="echo "$email";" class="gform_hidden" aria-invalid="false">

Instead I should get:

<input name="input_6" id="input_5_6" type="hidden" value="My job title" class="gform_hidden" aria-invalid="false">

and

<input name="input_5" id="input_5_5" type="hidden" value="myaddress@email.com" class="gform_hidden" aria-invalid="false">

Can someone could point me in the right direction.

Thank you.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...