Updating the primary key
This has served my purpose for now, but if there are no other candidate keys, how should we do it? PDF (US Ltr) - 37.4Mb PDF (A4) - 37.4Mb PDF (RPM) - 36.9Mb EPUB - 10.6Mb HTML Download (TGZ) - 10.3Mb HTML Download (Zip) - 10.4Mb HTML Download (RPM) - 9.0Mb Eclipse Doc Plugin (TGZ) - 11.2Mb Eclipse Doc Plugin (Zip) - 13.4Mb Man Pages (TGZ) - 204.7Kb Man Pages (Zip) - 311.7Kb Info (Gzip) - 3.4Mb Info (Zip) - 3.4Mb My SQL Backup and Recovery My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication Using the My SQL Yum Repository My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows My SQL NDB Cluster 7.5 statements are flagged as unsafe for statement-based replication.This specifies that the linkage between the two rows should be created using an UPDATE statement after both rows have been INSERTED; it also causes the rows to be de-associated with each other via UPDATE before a DELETE is emitted.The flag should be placed on just When a structure against the above configuration is flushed, the “widget” row will be INSERTed minus the “favorite_entry_id” value, then all the “entry” rows will be INSERTed referencing the parent “widget” row, and then an UPDATE statement will populate the “favorite_entry_id” column of the “widget” table (it’s one row at a time for the time being): BEGIN (implicit) INSERT INTO widget (favorite_entry_id, name) VALUES (? ) (None, 'somewidget') INSERT INTO entry (widget_id, name) VALUES (? ) (1, 'someentry') UPDATE widget SET favorite_entry_id=? (1, 1) COMMIT When the primary key of an entity changes, related items which reference the primary key must also be updated as well.
Becoz update override only works when the row is marked as update Thnx JK" id="ctl00_m_m_i_ctl00_gr_ctl07_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="2320764" / The easies way to update the primary key through informatica is to use the update override option present in the target table. But remember before using the update override do not forget to link all ports to the target and use update stratergy trans formation and dd_update or treat source rows as update.They add additional column ports to recieve new primary key column values you need to update.