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

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

Do you find any difficulty while working with flat files as source and target?

0 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

can u give example for factless fact table

2 Answers   TCS,

How do you use reject loader.

0 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers