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

Repository user profiles

0 Answers  

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

Global and Local shortcuts. Advantages.

0 Answers  

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

Why we use partitioning the session in informatica?

2 Answers  

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

r u done any partitions in ur project?

0 Answers   TCS,

how can import the data from the flat files?

2 Answers  

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

What is different between the data warehouse and data mart?

0 Answers  

For more Informatica Interview Questions Click Here
Categories