how we can update a target table without update strategy and
update override?

Answers were Sorted based on User's Feedback



how we can update a target table without update strategy and update override?..

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

how we can update a target table without update strategy and update override?..

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

how we can update a target table without update strategy and update override?..

Answer / sehaj

BY USING DYNAMIC LOOK UP CACHE!

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  


Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  


What is an expression transformation?

0 Answers  


What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,


Major difference between SQL override and Lookup Sql override

1 Answers  






What does reusable transformation mean?

0 Answers  


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,


what is the incremental agrrigation?

2 Answers   Cap Gemini,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


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

3 Answers   TCS,


Categories