without using rank transformation how can we rank items by
using some other transformations
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 |
how to load dimension table and fact table. plz tell me the steps.
What are the session parameters?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
How/where can i install Informatica software with oracle or teradata as database
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
How can you differentiate between powercenter and power map?
What is query panel?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Kimball and Inmon methodologies?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
what are types of dimentions?