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
- 10441 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
How many ways are there to create ports?
How many types of sessions are there in informatica.please explain them?
What is lookup transformation?
How many dimensions are there in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
Can we create two repositories on same database instance in oracle?
What is a joiner transformation?
What is domain in terms of informatica?
What are batches?
What are active and passive transformations?
What is the meaning of up gradation of repository?
can u any challenge your project?
Explain the different kinds of facts.
is it possible to index the data in cache of lkp transformation ?
what is unit testing?tell me proceedure
