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
- 10544 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
server hot-ws270 is connect to Repository B. What does it mean?
what is Active lock explain
What does “tail –f” command do and what is its use as an Informatica admin.
Difference between Data and Index Caches?
Can u generate reports in Informatica?
What is repository manager?
Mention a few design and development best practices for informatica?
design of staging area?
What is informatica powercenter repository?
What is persistent lookup cache?
Describe an informatica powercenter?
How to generate sequence numbers?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Why do you use Mapping Parameter and mapping variable?
How many ways a relational source definition can be updated and what are they?
