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?/

Answer Posted / 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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many input parameters can exist in an unconnected lookup?

1258


How to create Target definition for flat files?

956


What is sequence generator transformation in informatica?

799


What are the informatica performance improvement tips

807


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

802






What is a difference between complete, stop and abort?

822


Explain the mapping variable usage example in informatica

826


What is informatica? Why do we need it?

833


Can you generate sequence numbers without using the sequence generator transformation?

789


What is the sequence generator transformation in informatica?

843


Global and Local shortcuts. Advantages.

1650


What are Dimensional table?

783


What is a filter transformation?

786


Differences between version 7.x and 8.x.

1616


How to extract sap data using informatica? What is abap? What are idocs?

775