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 is a sequence generator transformation?
Differentiate between a database and data warehouse?
How can one identify whether mapping is correct or not without connecting session?
Differences between connected and unconnected lookup?
how we can load rejected record's at run time?(not through bad files)
How to generate sequence numbers using expression transformation?
Describe data concatenation?
What is a shortcut and copy in Informatica and how two are different with each other?
Mention few advantages of router transformation over filter transformation.
How to configure mapping in informatica?
How do you convert single row from source into three rows into target?
What is mapping debugger?
what are the deliverables?in your project?
what is size of u r database?
Explain where to store informatica rejected data? How to extract the informatica rejected data?