Answer / rk

use lookup override as

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

Answer / rambabu

Hi gurpreet, we cant use > simble with romnum,
the answer given by RK is obsolutly correct

Answer / sujana

create a flatfile for 1st and 2nd records...keep lukup on dis table..if condition doesnt match it inserts the record (use not equal operator in condition)..

crct me if im wrong

Answer / jack

Lookup SQL override will help you to achieve this

Answer / gurpreet

select from emp where rownum> 2;
se this in sql override

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

---

what is the difference between stop and abort?

3 Answers   TCS,

---

whatis the default data driven operation in informatica

2 Answers  

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

What are the new features in Informatica 5.0?

1 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---