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

On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?

Answer Posted / rohan

Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is metadata stored?

1189


Under which circumstances, informatica server creates reject files?

1137


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1144


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1126


What are the new features of informatica 9.x at the developer level?

1105


Whats there in global repository

1737


What is the function of union transformation?

1201


r u done any partitions in ur project?

1862


Explain joiner transformation in informatica

1171


How does a sorter cache works?

1109


As union transformation gives UNION ALL output, how you will get the UNION output?

1158


What is a difference between complete, stop and abort?

1124


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

2126


How we can create indexes after completing the load process?

1199


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3921