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
- 15123 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhupal
Use sorter t/r first and sort the data by using which port
u want
next use that expression t/r to generate the sequence by
using variable port
next u can use the filter t/r to restrict the data or
required ranks as a output.
| Is This Answer Correct ? | 2 Yes | 0 No |
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
Is there any way to read the ms excel datas directly into informatica?
How to Join Tables my Source is having 15 table target is one?
How can we improve session performance in aggregator transformation?
What is the advantage of persistent cache? When it should be used.
What is the difference between IN and Exists in Oracle?
What is difference macros and prompts?
What happens when a session fails and you click on recover?
Implementation methodology
Explain the difference between mapping parameter and mapping variable?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Teradata 
