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 can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Answer Posted / chandrasekar

Hi Sudhar,

Please check your answer it is not working....

We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.

If it wrong means please mail me.. chandranmca2007@gmail.co

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in reporting we add some new objects,how we get the count of the newly added objects to the report

2129


Differences between version 7.x and 8.x.

1839


Describe the impact of several join conditions and join order in a joiner transformation?

1006


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020


How to extract sap data using informatica?

981


Explain what are the different versions of informatica?

1030


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1994


what is $$$$?

2093


Quickly characterize reusable change?

1057


Briefly define reusable transformation?

1074


Explain lookup transformation source types in informatica

1038


which one is better performance wise joiner or look up

1025


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1024


Explain the use of aggregator cache file?

1185


What is the surrogate key?

1143