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...


How to load duplicate records in to a target table which
has a primary key?

Answers were Sorted based on User's Feedback



How to load duplicate records in to a target table which has a primary key?..

Answer / pradeeshkumar

Loading duplicate records into a target table which has a
primary key is just a height of Brain failure.
The concept of primary key itself fails. If you still want
to insert it, better don't have any primary key

Is This Answer Correct ?    6 Yes 2 No

How to load duplicate records in to a target table which has a primary key?..

Answer / jay

Is that primary key column in the target is different,
than this is called surrogate key which is obtained
from Sequential generator (with or without combination of
key value from source. if combined with source primary key
column, then it is known as creating frequency for
each source primary column value)

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Informatica Interview Questions

Define Incremental Aggregation?

2 Answers  


What are the differences between source qualifier and joiner transformation?

0 Answers  


Issue with Update override at Target table in Informatica.

2 Answers  


i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,


How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,


What will be the approach?

0 Answers  


How to recover the standalone session?

2 Answers  


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


Can you use one mapping to populate two tables in different schemas

2 Answers  


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


What do you understand by a term domain?

0 Answers  


What are the popular informatica products?

0 Answers  


Categories