Interested to Buy Any Domain ? << Click Here >> for more details...
without using rank transformation how can we rank items by
using some other transformations
- 2 Answers
- 15262 Views
- I also Faced
- E-Mail Answers
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
What is data caches/ index caches?
How big was your fact table
Explain the scenario which compels informatica server to reject files?
How to do unit testing in informatica?
explain one complex mapping with logic? sales project?
To import the flat file definition into the designer where should the flat file be placed?
Differentiate between reusable transformation and mapplet.
Difference between Target-based loading and constraint-based loading?
Explain the difference between a data warehouse and a data mart?
Explain dynamic target flat file name generation in informatica
What does command task mean?
In informatica workflow manager, how many repositories can be created?
What is an unconnected transformation?
Explian the Process of deployment groups in informatica
Clarify the utilization of aggregator cache record?
