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
- 6665 Views
- I also Faced
- E-Mail Answers
Answer Posted / anoymous
In rank t/r select properties tab
select top and number of ranks is 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to call shell scripts from informatica?
What is the need of an ETL tool?
Where are the source flat files kept before running the session?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the reusable transformations?
without table how to come first record only in oracle?
What is decode in static cache?
How can a transformation be made reusable?
What are the types of schemas we have in data warehouse.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the types of data warehouses?
How to delete duplicate row using informatica?
what is $$$$?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
