How to update records in Target, without using Update Strategy?
Answers were Sorted based on User's Feedback
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 |
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 load only the first and last record of a flat file into the target?
Performance wise which is better joiner or look up ? Give me with example?
design of staging area?
What is batch and describe about types of batches?
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 .
What is query panel?
Performance tuning in UNIX for informatica mappings?
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?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
have u done any performance tuning? how u ll do?
What is the maplet?
what are the different types of transformation available in informatica and what are the mostly used ?