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

what we require for D.modelling?

1 Answers  

Reusable transformation and shortcut differences

0 Answers  

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

What is difference between a connected look up and unconnected look up?

6 Answers  

what is the process of target load planing?

2 Answers   IBM,

How to start a workflow using pmcmd command?

0 Answers  

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,