top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to add an intermediate calculated “variable” in informatica

+2 votes
383 views

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?

posted May 6, 2014 by Madhavi Kumari

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

2 Answers

+1 vote

Use Expression Transformation after Source A Qualifier to perform calculation after that you can join through Joiner Transformation.

answer May 6, 2014 by Shatark Bajpai
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 May 7, 2014 by Shweta Singh
Similar Questions
+2 votes

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?

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.

...