empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
Answer Posted / ,ike
well as per my knowledge
sc-->sq-->rank t/r-->target
In the rank transformation need to check rank port of sal
and group by empno.
correct me if i was wrong
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How are the sources and targets definitions imported in informatica designer?
server hot-ws270 is connect to Repository B. What does it mean?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the way to execute pl/sql script using informatica mapping?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to create Target definition for flat files?
What are the types of caches in lookup? Explain them.
What is Session and Batches?
explain about unit testing? in real time?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain the etl program with few examples.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the session task and command task?
What is the function of union transformation?
What is joiner change?