There are tables where the primary key is not a database sequence, nor a consecutive integer, but a column which is built based on a rule or pattern that depends on the keys already inserted. For example imagine a table where the values for primary key are
A00001, A00002, and
A00003. In this case, you can guess the rule: putting an
A followed by a sequence. The next in the sequence would be
A00004. This seems too simple, but doing it in PDI is not trivial. This recipe will teach you how to load a table where a primary key has to be generated based on existing rows as in that example.
Suppose that you have to load author data into the book's database. You have the ...