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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Under which circumstances, informatica server creates reject files?

1086


What is lookup transformation?

1038


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244


Global and Local shortcuts. Advantages.

2032


How do you migrate data from one environment to another?

1092


What is the session task and command task?

1052


Explain what are the different versions of informatica?

1095


What are the reusable transformations?

1159


Name the different lookup cache(s)?

1228


tell me 5 session failure in real time how can you solve that in your project?

2291


What is the sql query overwrite in source qualifier in informatica

1085


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4726


State the limitations where we cannot use joiner in the mapping pipeline?

1060


How to update a particular record in target with out running whole workflow?

1575


How can you increase the performance in joiner transformation?

1184