Interested to Buy Any Domain ? << Click Here >> for more details...
empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
- 3 Answers
- 6473 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
In rank t/r select properties tab
select top and number of ranks is 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ganesh
write a query like
select * from <table_name> order by where sal=(select max(sal) from <table_name>)
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ,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 |
Do you find any difficulty while working with flat files as source and target?
What are the disadvantages of Sequence Generator T/R?
What are the differences between joiner transformation and source qualifier transformation?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
what is constraint based load order
What is depict expression change?
What are the two modes of datamovement in informatica sever?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
What are multi-group transformations?
How will you update the first four rows and insert next four rows in a mapping?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Teradata 
