Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / mehul.thakur

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

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

What is a configuration management?

1 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

Different types of Power center errors?

1 Answers   Cinterco, IBM,

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

WHat all joins are there in Source Qualifier?

1 Answers  

For more Informatica Interview Questions Click Here
Categories