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

How to update records in Target, without using Update Strategy?

Question Posted / kumar

Answers were Sorted based on User's Feedback



How to update records in Target, without using Update Strategy?..

Answer / pooja

YES WITHOUT A pk WE CANT UPDATE THE REC....

IN SESSION PROPERTIES WE HAVE ONE OPTION TREAT ALL ROWS
AS... THERE U SELECT UPDATE OPTION AND IN THE TARGET
PROPERTIES SELECT UPDTAE OPTION

Is This Answer Correct ?    13 Yes 0 No

How to update records in Target, without using Update Strategy?..

Answer / 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

How to update records in Target, without using Update Strategy?..

Answer / nagesh

According to my knowledge, in session properties, update
property is there. just you enable the update property.

if it is wrong, give me right ans
thank you

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Quickly characterize reusable change?

0 Answers  

what is semi-additive fact?where did u used?

2 Answers  

How an expression transformation differs from aggregator transformation?

0 Answers  

Scheduling properties,whats the default (sequential)

0 Answers  

what is sql override?what is the use of it?

4 Answers   Sonata,

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

What is the target load order?

3 Answers   HCL, Informatica,

How many input parameters can exist in an unconnected lookup?

0 Answers  

How many repositories can be created in informatica?

1 Answers  

What is complex mapping?

0 Answers  

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

For more Informatica Interview Questions Click Here
Categories