How will you update the row without using update statergy?

Answer Posted / sweta kedia

In target,there is a update override option of updating the
records using the non-key columns. Using this one wecan
update the records without using update strategy t/r

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2426


4 yrs etl devloper roles and responsibilities?any body give solutions

1577


What is flashback table ? Advance thanks

1481


How you know when to use a static cache and dynamic cache in lookup transformation?

1340


What are the types of data warehouses?

944






Partition, what happens if the specified key range is shorter and longer

2029


What is the Rank index port in Rank transformation?

669


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

553


What is the difference between informatica 7.0 and 8.0?

567


Explain sessions and how many types of sessions are there?

581


Briefly explain the aggregator transformation?

594


What does cheating measurement mean?

600


In development project what is the process to follow for an etl developer from day1

1281


How do you load first and last records into target table?

666


What is repository manager?

535