Previous Scenarios
Scenario: A source table contains emp_name and salary columns. Develop an Informatica mapping to load all records with 5th highest salary into the target table.
Solution:
The mapping will contain following transformations after the Source Qualifier Transformation:
1. Sorter : It will contain 2 ports - emp_name and salary. The property 'Direction' will be selected as 'Descending' on key 'Salary'
2. Expression transformation: It will 6 ports as follows -
a> emp_name : It will be an I/O port directly connected from previous sorter transformation
b> salary_prev : It will be a variable type port. Give any vriable name e.g val in its Expression column
c> salary : It will be an I/O port directly connected from previous transformation
d> val : It will be a variable port. The expression column of this port will contain 'salary'
e> rank: It will be a variable type port. The expression column will contain decode
(salary,salary_prev,rank,rank+1)
f> rank_o : It will be an output port containg the value of 'rank'.
3. Filter Transformation : It will have 2 I/O ports emp_name and salary with a filter condition rank_o = 5
The ports emp_name and salary from Filter Transformation will be connected to target
Posts
negative regexp
-
if you want to grep anything except foo, use grep -v or negative lookahead
echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so
beautiful ...
1 month ago
4 comments:
We can use the rank transformation here directly after sorter.
we can directly use a rank transformation rather using all these .
more transformation , more expensive mapping :(
Hi,If rank transformation is used we cannot get all the names whose salary stood 5th position.
ex:
aa,1000
ab,100
ac,200
ad,300
ae,400
af,1000
Here aa and af stood in the 5th position.Then if we use rank transformation we cannot get the 2 records whose salary stood position 5.
Is it correct???
I think Informatica is the best way of providing some more and useful information and aspects to focus which are related to IT problems.
Informatica Read Soap API
Post a Comment