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
what is the Default Source Option For Update Strategy Transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain transaction control transformation in informatica
What is the surrogate key?
r u done any partitions in ur project?
What does role playing dimension mean?
How can we create index after completion of load process?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the databases that informatica can connect to windows?
What is a stored procedure transformation?
How can we use batches?
How can we improve session performance in aggregator transformation?
What is the Process to creating lookup transformation in informatica
Name the different lookup cache(s)?
Explain how to import oracle sequence into informatica?