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
- 21688 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanju
select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
In warehouses how many schemas are there?
How to load the data from people soft hrm to people soft erm using informatica?
I have a flat file, want to reverse the contents of the flat file
How many types of sessions are there in informatica.please explain them?
State the differences between sql override and lookup override?
wf dont have integration severances how you can run?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are mapplets?
How do you load only null records into target?
What is fact table? Explain the different kinds of facts.
How can we store previous session logs?
What is a repository? And how to add it in an informatica client?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How can we use mapping variables in informatica?
