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

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

When the informatica server marks that a batch is failed?

1 Answers  

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

What is junk dimention?

3 Answers   Patni,

What is incremental aggregation?

0 Answers  

Difference Between ETL & ELT?

1 Answers   TCS,

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

What are the two modes of datamovement in informatica sever?

2 Answers  

Mention few advantages of router transformation over filter transformation.

0 Answers  

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

When to use normalization transformation other than cobol source?

2 Answers  

What do you mean by enterprise data warehousing?

0 Answers  

For more Informatica Interview Questions Click Here
Categories