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
What are the advantages of informatica?
How to differentiate between the active and passive transformations?
how to load dimension table and fact table. plz tell me the steps.
Differentiate between joiner and lookup transformation?
What is target load order?
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
Is it possible to create multiple domains on a single Informatica server?
What is union transformation?
can we override a native sql query within informatica? Where do we do it?
What do you mean by channel change?
What is the session task and command task?
What is sq transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
How do you load only null records into target?
How would you join a node to the already existing domain?