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

Explain pmcmd command usage in informatica

0 Answers   Informatica,

What are the Advantages of de normalized data?

3 Answers  

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

What is meant by incremental aggregation?

0 Answers  

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

How to display null values on a target & non-null values on a target?

3 Answers  

Major difference between SQL override and Lookup Sql override

1 Answers  

can anyone suggest best free Talend data integration training online

0 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

Why use the lookup transformation ?

2 Answers   Informatica,

What is a taget load order?

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories