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

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

How can you differentiate between powercenter and power map?

0 Answers  

What is a design?

1 Answers  

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

Why use the lookup transformation ?

2 Answers   Informatica,

how tokens will generate?

0 Answers  

What is the difference between Normal load and Bulk load?

5 Answers  

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

For more Informatica Interview Questions Click Here
Categories