can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / nagaraju bhatraju
Other than this option like "Target update Override "
you can drag that target Warehouse desiner ,and mark those
columns which are no keys as a key for time being ,on whihc
you are trying to update. even though those columns are
not keys attributes or key columns at database level,for
time being those will be treated as key elements, hense you
can apply or use update strategy .
else generally informatica will through error like
" No key specification error"
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what are 3 tech challenges/ common issues you face?
What is primary and backup node?
what is the Default Source Option For Update Strategy Transformation?
On which transformations you created partitions in your project?
Explain incremental aggregation in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the use of an aggregator cache file?
How many input parameters can exist in an unconnected lookup?
What are the components of the workflow manager?
What are the new features of Power Center 5.0?
What are the new features of informatica 9.x in developer level?
What does refresh system mean, and what are its distinctive choice?
What are the issues you have faced in your project? How did you overcome those issues?