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


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

541


How we can create indexes after completing the load process?

584


How we can use union transformation?

581


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1610


Partition, what happens if the specified key range is shorter and longer

2007






Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

782


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1505


How can we remove the duplicates from flat file source?

546


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

602


What is Cognos script editor?

3765


What is the use of code page?

567


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1428


Please let me know how to make encryption and decryption with example?

1426


Explain load alternative records / rows into multiple targets - informatica

650


Differentiate between a database and data warehouse?

626