Sunday, 19 February 2017

Inforamtica cloud Scenerios- Generate Fibonacci numbers using with inforamtica cloud mapping.

1. Generate Fibonacci numbers using with inforamtica cloud mapping.

Source:                         Trg
1                                  1
2                                  2
3                                  3
.                                   5
.                                   8
.                                   13
.                                   21
50                                34


Ans:

Create source table with above data and select that table as source as shown below. i have crated a table name s EMP.


Create one expression transformation and drag the connection to expression. and from properties tab go to the expression tab and create  3 variable ports and 1 o/p port  and  apply the same logic for each port as shown Below.


 Create a filter transformation and drag a connection from expression to filter t/r and apply the filter logic as shown below.


Create a Target t/r and connect the o/p port to target as shown below.