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
How identifying bottlenecks in various components of informatica and resolving them?
how to load dimension table and fact table. plz tell me the steps.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is source qualifier transformation in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is domain and gateway node?
What's the layout of parameter file (what does a parameter file contain?)?
What is the use of code page?
difference between informatica 8.1.1 and 8.6
how many types of dimensions are available in informatica?
What are the new features of informatica 9.x in developer level?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a predefined event?
What are the performance considerations when working with aggregator transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?