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

What are the differences between oltp and olap?

972


Is stop and abort are same in informatica?

1002


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2077


Tell me about MD5 functions in informatica

929


Mention some types of transformation?

1048


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?

1248


What are the tasks that can be performed using sq?

1093


What is difference between a gateway node and worker node?

1141


what are factless facts? And in which scenario will you use such kinds of fact tables.

1810


Explain the mapping variable usage example in informatica

1165


Explain sql transformation in script mode examples in informatica

1135


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1130


What are different types of transformations available in informatica?

993


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1086


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2519