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


what is target update override and when we use it?

Answers were Sorted based on User's Feedback



what is target update override and when we use it?..

Answer / moorthy g

Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.

Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy

Is This Answer Correct ?    2 Yes 0 No

what is target update override and when we use it?..

Answer / ankur saini er.ankur861@gmail.

Hi

Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,


How to recover the standalone session?

2 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,


my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,


How to delete the data in the target table after loaded.

3 Answers   TCS,


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


What is the use of code page?

0 Answers  


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,


How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,


How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,


Categories