Interested to Buy Any Domain ? << Click Here >> for more details...
how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 25406 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / gyana
SELECT RN,EMPNO,ENAME,SAL FROM
(SELECT ROWNUM RN,EMPNO,ENAME,SAL FROM EMP)
WHERE RN IN (1,3,5)
---------------------------------------------------
I ALREADY TESTED ITS WORKING..PLS ANY CORRECTION LET ME KNOW
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What does command task mean?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain how to import oracle sequence into informatica?
Do you find any difficulty while working with flat files as source and target?
how we can load rejected record's at run time?(not through bad files)
What are the modules in Power Center
What is a dimensional model?
Explain the types of transformations?
What is meant by query override?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to join three sources using joiner? Explain though mapping flow.
explain about unit testing? in real time?
How do you load first and last records into target table?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
