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

Mention few power centre client applications with their basic purpose?

0 Answers  

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

What is a joiner transformation and why it is an active one?

0 Answers  

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

what is dimension table?

17 Answers  

how to convert the .doc docs into .txt format using informatica

4 Answers  

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

What is a sequence generator transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories