use lookup override as select *from emp minus select *from emp where ro

when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/

Question Posted / rk

Answer Posted / rk

use lookup override as

select *from emp minus select *from emp where rownum<=2

Is This Answer Correct ?

18 Yes

1 No

Please Help Members By Posting Answers For Below Questions

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2049

What do you understand by SOA of Informatica?

1046

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5796

What is the surrogate key?

1367

What do you mean by blocking transformation?

1120

Why sorter is an active transformation?

1252

What is InformaticaPowerCenter?

1179

Explain joiner transformation in informatica

1174

What is the use of target designer?

1122

Reusable transformation and shortcut differences

1884

What are the new features of informatica 9.x in developer level?

1055

How will the document be delivered to me?

1131

What is lookup transformation?

1096

r u done any partitions in ur project?

1869

Can we create two repositories on same database instance in oracle?

1147