without using rank transformation how can we rank items by
using some other transformations
Answer Posted / sukanta
how your rank will look like
let suppose
ename sal
a 1000
b 1000
c 2000
d 1000
e 2000
and rank will work upon sal column.
what will be your target as per informatica rank works
ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 4
d 2000 5
if your rank will like this
ename sal rank
a 1000 1
b 1000 2
d 1000 3
c 2000 4
d 2000 5
or
ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 2
d 2000 2
all are can be done by using expression
transformation,sorter and aggrerator transformation combined
in a mapping.
Regards
Sukanta
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain the code page compatibility?
What are the different options available for update strategy?
What is the status code in stored procedure transformation?
what is mean by complex business rule ?
In warehouses how many schemas are there?
Explain sessions and how many types of sessions are there?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the -ve test case in your project.
what is song in infrmatica...?
What is a grid in Informatica?
Explain load alternative records / rows into multiple targets - informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
How are the sources and targets definitions imported in informatica designer?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the use of target designer?