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

What are the advantages of informatica?

584


How to differentiate between the active and passive transformations?

635


how to load dimension table and fact table. plz tell me the steps.

1696


Differentiate between joiner and lookup transformation?

626


What is target load order?

816






hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9185


Is it possible to create multiple domains on a single Informatica server?

762


What is union transformation?

581


can we override a native sql query within informatica? Where do we do it?

640


What do you mean by channel change?

558


What is the session task and command task?

608


What is sq transformation?

679


Suppose we do not group by on any ports of the aggregator what will be the output?

588


How do you load only null records into target?

749


How would you join a node to the already existing domain?

696