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
- 15248 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 |
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What are the components of the workflow manager?
Explain what transformation and how many are there in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
how to calculate the optimum cache size in aggregator transformation?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
How to generate a single mapping for both the historical and incremental load.
To achieve the session partition what r the necessary tasks u have to do?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Briefly describe lookup transformation?
Teradata 
