can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / bsgsr
no using update strategy without primary keys update is not
possible. try and read teh session log file once. it will
display a msg updates are not supported without primary
keys.
update override in the target is to update the function in
the update strategy t/tion and it updates only on non-
primary key columns like dname, loc but not on deptno.
gilbert can i have your mail id here is mine
bsinivas1213@gmail.com
else call me on my num 9866188658 once v can have kt which
is mutually beneficial
Is This Answer Correct ? | 22 Yes | 1 No |
Post New Answer View All Answers
Explain the different kinds of facts.
How we can create indexes after completing the load process?
How we can use union transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Partition, what happens if the specified key range is shorter and longer
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we remove the duplicates from flat file source?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is Cognos script editor?
What is the use of code page?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Please let me know how to make encryption and decryption with example?
Explain load alternative records / rows into multiple targets - informatica
Differentiate between a database and data warehouse?