how we can update a target table without update strategy and
update override?
Answers were Sorted based on User's Feedback
Answer / moorthy g
In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / bhupal
In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.
Is This Answer Correct ? | 1 Yes | 0 No |
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What is an expression transformation?
What is use of batch file in informatica? How many types of batch file in informatica?
Major difference between SQL override and Lookup Sql override
What does reusable transformation mean?
Which version configuration tool used in ur project?
What is the exact difference b/w IN and EXIST in Oracle..?
If I am having 6 flat files in data. How can you load the data at a time
what is the incremental agrrigation?
What are the guidelines to be followed while using union transformation?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer