2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?

Answer Posted / sehaj

DUPLICATE DATA CANOT B INSERTED USIN DYNAMIC LOOK UP
CACHE..BCOZ DYNAMIC LOOK UP CACHE PERFORMS ONLY UPDATE N
INSERT FUNCTION BASED ON THE KEYS IT GETS IN THE TARGET
TABLE N LOOK UP TABLE...

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How identifying bottlenecks in various components of informatica and resolving them?

686


How do you load first and last records into target table?

783


Which means the first record should come as last record and last record should come as first record and load into the target file?

695


What are different types of transformations available in informatica?

668


Design time, run time. If you don't create parameter what will happen

1519






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

657


How do you update the records with or without using update strategy?

755


Design a mapping to load the cumulative sum of salaries of employees into target table?

1025


What is mapplet in informatica?

669


What is the use of source qualifier?

779


What is deployment group?

774


What is standalone command task?

816


Write the different tools in the workflow manager?

662


How to generate sequence numbers using expression transformation?

729


Explain how to import oracle sequence into informatica?

675