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 the primary key are
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.
Suppose that you have to load author data into the
book's database. You have the main data for ...