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


Can we update a target table (without primarykey) by using
update strategy transformation?

Answers were Sorted based on User's Feedback



Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / ratalarayudu

hi ,

Yes we can update a target table without having a primary
key. we have a property TARGET UPDATE OVERIDE .By overring
we can update .


Regards,
Rayudu.

Is This Answer Correct ?    27 Yes 0 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / zak

1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know

Is This Answer Correct ?    6 Yes 2 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / mithilesh kumar rai

With Same logic with Update Strategy tr,
just Select Primary Key Option in Target Table Definition.

It will work without defining the Target table.

Regards
Mithilesh Kumar Rai

Is This Answer Correct ?    0 Yes 6 No

Can we update a target table (without primarykey) by using update strategy transformation?..

Answer / maheedhar

I said No,Kindly correct me if am wrong.......

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Informatica Interview Questions

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  


what is lookupoverriding?

1 Answers  


What is the difference between a repository server and a powerhouse?

0 Answers  


How to handle decimal places while importing a flatfile into informatica?

0 Answers  


What are the different versions of informatica?

0 Answers  


how to remove staging area

1 Answers  


"Change cache" in Informatica ?

2 Answers  


How to delete duplicate record in Informatica?

7 Answers  


in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,


what is the method of error handling when session is running?

1 Answers   TCS,


what is mapping parameter?

2 Answers   Cap Gemini,


How to recover the standalone session?

2 Answers  


Categories