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
- 21747 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikanth
id sal
101 1000
102 1000
103 1000
104 1000
select id, sal from emp where rownum<=3
minus
select id, sal from emp wwhere rownum<=2;
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a rank transform?
What is the status code in stored procedure transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Define Pmrep command?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is dynamic cache?
How are indexes created after completing the load process?
Which are the different editions of informatica powercenter that are available?
How to improve the performance of a session using sorter transformation?
what are 3 tech challenges/ common issues you face?
