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
- 6346 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 |
What is the meaning of up gradation of repository?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is mapplet in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
How do you implement unconn. Stored proc. In a mapping?
Describe two levels in which update strategy transformation sets?
How to import oracle sequence into Informatica?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
Mention a few design and development best practices for informatica?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Explain about Recovering sessions?
Teradata 
