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

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

In target table how to display the system time

1 Answers  

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

What are the different types of repositories created using informatica?

0 Answers  

---