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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / maheedhar

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

&#61656; Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

What are the different threads in DTM process?

2 Answers  

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

Explain about Recovering sessions?

1 Answers  

What are the types of lookup?

3 Answers   Wipro,

Why update strategy and union transformations are active?

0 Answers  

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

disable caching in a lookup transformation?

1 Answers  

Without source how to insert record to target?

6 Answers  

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories