Your organization needs to integrate data from different databases, and you need to generate unique IDs that are unique across systems. A regular ID is unique within the table of the database. However, there may be a conflict of ID numbers when you integrate data from different databases. If the IDs are integers, an external entity can decipher the number of records and size of the database. To generate unique, non-numeric IDs, use a UUID that is unique across systems and which you can generate using an external application.You can use a passive Java transformation in a mapping to generate a UUID and send it to the target system. You can use the Java transformation to define simple or moderately complex transformation functionality without advanced knowledge of the Java programming language or an external Java development environment. The attachment contains a sample mapping and How-To document explaining the use case and implementation. You can download this listing as part of the Bundle : Java Transformation.