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

without dynamic lookup transformation how to insert new
rows and update existing rows?

Answer Posted / jhansi

YES,we can insert new rows and updat existing row
By setting Session level properties
1.Session->properties->TreatSourceRowas Update
2.Session->mapping->target properties->select update else
insert

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways to implement parallel processing in informatica?

1340


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

900


What is decode in informatica?

1072


Explain the mapping variable usage example in informatica

1082


What is the reusable transformation?

1006


What are ETL Tools?

1040


Which are the different editions of informatica powercenter that are available?

971


How can we improve session performance in aggregator transformation?

1039


Explain why we use partitioning the session in informatica?

1006


Explain sql transformation in script mode examples in informatica

1046


How can we remove the duplicates from flat file source?

948


What is update strategy transform?

1015


How identifying bottlenecks in various components of informatica and resolving them?

1055


What is resilience time?

1048


What are the different components of powercenter?

986