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
What are mapplets? How is it different from a Reusable Transformation?
Name the different lookup cache(s)?
What are the differences between joiner transformation and source qualifier transformation?
Explain informatica architecture - version 8 / 9
What is different between the data warehouse and data mart?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can you use flat files in Mapplets.
Separate from a database, an information bazaar, and an information stockroom?
Explain sessions and how many types of sessions are there?
Could you explain what is enterprise data warehouse?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Repository user profiles
On which transformations you created partitions in your project?
Design a mapping to load a target table with the following values from the above source?