Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10946 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jvdwhinfo
Hi There,
The DFD given in answer is absolutely correct in
informatica.
But coming to sql override stuff i agree with answer 4.
And i want to do little modification keeping performance in
view.
The modified query looks like this.
With salorder
As
(select * from emp)
select * from salorder where rownum <= 5
minus
select * from salorder where rownum <= 4;
Thanks,
James
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the uses of etl tools?
Is it possible to revert a global repository to local one and why?
What are the reusable transformations?
what is the size of u r source(like file or table)?
What are the popular informatica products?
Explain the scenario which compels informatica server to reject files?
What is a sequence generator transformation?
How can you validate all mappings in the repository simultaneously?
What does role playing dimension mean?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a node in Informatica?
Why union transformation is an active transformation?
What are the differences between source qualifier and joiner transformation?
How do you update the records with or without using update strategy?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
