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

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 load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


design of staging area?

0 Answers  


What is batch and describe about types of batches?

2 Answers  


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,






What is query panel?

1 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  


explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


What is the maplet?

0 Answers   Informatica,


what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,


Categories