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 to update records in Target, without using Update Strategy?

Answer Posted / brahma

the table does not have keys u can write sql query at target
level. in target table properties there is a option update
override.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1228


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7163


How to delete duplicate row using informatica?

1016


In informatics server which files are created during the session rums?

1104


How can you define user defied event?

1009


What is rank transformation in informatica

1151


waht type of interface is used for testing the data in informatica

2237


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2103


Explain lookup transformation in informatica

1048


What are the types of lookup transformation?

1053


can we override a native sql query within informatica? How do we do it?

1103


Which is the t/r that builts only single cache memory?

1175


Could you explain what is enterprise data warehouse?

1116


what is degenerated dimension?

3958


What are the modules in Power Center

1665