What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What are the advantages of informatica?
What is the function of aggregator transformation?
tell me the rules and responsblites in our project(my project is development)
Briefly define reusable transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Mention some types of transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How can we store previous session logs?
What is a repository? And how to add it in an informatica client?
How to do the error handling of if ur source is flatfiles?
How to handle decimal places while importing a flatfile into informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the settings that you use to configure the joiner transformation?
Do you find any difficulty while working with flat files as source and target?