Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 22101 Views
- I also Faced
- E-Mail Answers
Answer Posted / hardeep
We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is meant by query override?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is the Default Source Option For Update Strategy Transformation?
What is the difference between Active and Passive transformation?
Where can we find the throughput option in informatica?
Briefly define a session task?
Under what condition selecting sorted input in aggregator may fail the session?
Explain the use of aggregator cache file?
What do mean by local and global repository?
What is event and what are the tasks related to it?
What is rank transformation in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the status code in stored procedure transformation?
Explain sql transformation in script mode examples in informatica
