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 the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)

Answer Posted / ramesh

this can achieved using Update statergy
we have option in UPD or Target update override

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation?

1094


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2059


What is Cognos script editor?

4219


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1318


What is a sequence generator transformation?

1010


How can we store previous session logs?

1064


How to generate or load values in to the target table based on a column value using informatica etl tool.

1060


What is joiner transformation?

1006


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

2510


Parameter and variable differences

2055


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2716


Explain the etl program with few examples.

1045


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2030


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2114


What is the format of informatica objects in a repository?

1016