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
- 10687 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
State the differences between sql override and lookup override?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
without table how to come first record only in oracle?
what is the size of u r source(like file or table)?
Write the unconnected lookup syntax and how to return more than one column.
How can we handle two sessions in informatica?
Define pmcmd command?
What are the components of the workflow manager?
What is an Integration service in Informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
generate date / time dimension in informatica
How many ways a relational source definition can be updated and what are they?
How to use pmcmd utility command?
Describe the impact of several join conditions and join order in a joiner transformation?
What is an expression transformation?
