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
- 22055 Views
- I also Faced
- E-Mail Answers
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
How do you load first and last records into target table?
What do you understand by SOA of Informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
scenario where i can use only concurrent execution of workflow.
What is a joiner transformation and why it is an active one?
Explain the scenario which compels informatica server to reject files?
What is session task and command task?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What does command task mean?
What is target load order?
Differentiate between joiner and lookup transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
where to store informatica rejected data?
Explain how to import oracle sequence into informatica?
