How to update records in Target, without using Update Strategy?
- 3 Answers
- 10683 Views
- I also Faced
- E-Mail Answers
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 |
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Global and Local shortcuts. Advantages.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
what is incremental data aggregation?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
What is enterprise data warehousing?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
how eliminate the duplicates in flat file with out using sorter ,aggregater
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What are the different types of Type2 dimension maping?
what is target update override and when we use it?
Teradata 
