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
- 25226 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
What do you mean by channel change?
Explain the different kinds of facts.
How does a rank transform differ from aggregator transform functions max and min?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define the various join types of joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the status code in stored procedure transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to update a particular record in target with out running whole workflow?
How might one distinguish in the case of mapping is right or not without associating session?
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,
permutations of mapplet
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a surrogate key?
