In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / gopi k
rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
What is the maplet?
What is a sequence generator transformation?
Differentiate between router and filter transformation?
In which transformation you cannot drag ports into it?
How to configure mapping in informatica?
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?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to generate sequence numbers using expression transformation?
What are ETL Tools?
What is depict expression change?
How to load last n records of file into target table - informatica
Why filter transformation is an active one?
What is the session task and command task?