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 / murali raju

Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In development project what is the process to follow for an etl developer from day1

1673


Explian the Process of deployment groups in informatica

1009


What do you understand by SOA of Informatica?

947


have u done any performance tuning? how u ll do?

2259


What do you mean incremental aggregation?

1032


What are the differences between a connected lookup and unconnected lookup?

1029


Can anyone tell me the new features in Informatica 9 Version?

2060


What is informatica metadata and where is it stored?

958


Is it possible to create multiple domains on a single Informatica server?

1199


What do you understand by a term domain?

1087


What is a sequence generator transformation?

986


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2018


How would you copy the content of one repository to another repository?

973


In warehouses how many schemas are there?

1029


How to load the data from people soft hrm to people soft erm using informatica?

964