ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have just installed your ETL software and want to understand how to generate a unique value for a column every time a row is inserted to the table.
The value should be alphanumeric and my challenge is to make data writer to assign a unique value to the key column every time a new row insert is
done.

Please provide your suggestions.
Bob

Hi,

This is bizarre and unusual requirement.
Anyway customer is always right…

Does it have to be alpha numeric?
And what is your database type?

Basically depending on the database type
There are several options:
You can use Advanced ETL processor to generate ID’s or you can use database to generate ID’s

Advanced ETL processor:

1.First of all you ca use MD5 for the primary key this one is definitely alpha numeric
2.Or you can use Sequence function to generate ID’s
3 Or you can use Sequence function together with HEX function

Database

1.For MS Sql Server you can unique identifier fields together with newuid() function
Or you can use identity fields
2.For Oracle you can use sequences.

Peter