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
- 10730 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 mapping parameters and mapping variables?
Repository user profiles
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the tasks that can be performed using sq?
What is transformation?
What are the main features of Oracle 8i with context to datawarehouse?
Can we create multiple integration service on single repository?
Describe data concatenation?
How to extract the informatica rejected data?
What is update strategy transform?
Explain what transformation and how many are there in informatica?
r u done any partitions in ur project?
What is informatica? Why do we need it?
What are the tuning techniques you applied during your last project
Scheduling properties,whats the default (sequential)
