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

what is the predefined port in dynamic lookup

2 Answers  

What is the Rankindex in Ranktransformation?

7 Answers  

What are the informatica performance improvement tips

0 Answers   Informatica,

Can we create a Integration service without a Repository service and vice versa?

0 Answers  

What is workflow? What are the components of the workflow manager?

0 Answers  

What are the out put files that the informatica server creates during the session running?

2 Answers  

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

In a sequential batch can u run the session if previous session fails?

3 Answers  

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

What are the ETL tools available in DWH?

6 Answers   Mphasis,

For more Informatica Interview Questions Click Here
Categories