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

Answers were Sorted based on User's Feedback



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

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

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

Answer / ankur saini er.ankur861@gmail.

we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,


To achieve the session partition what r the necessary tasks u have to do?

1 Answers  


Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,


Make a note of the quantity vaults made in informatica?

0 Answers  


I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  


What are the Advantages of de normalized data?

3 Answers  


What are the new features of informatica 9.x at the developer level?

0 Answers  


Differentiate between joiner and lookup transformation?

0 Answers  


In a sequential batch can u run the session if previous session fails?

3 Answers  


Categories