Expression Transformation
Can Expression be used as Sequence transformation, if yes how?
February 20, 2017
Data Mining
Data Mining
February 21, 2017
Show all

How sequence can be used to assign missing values in a table?

Sequence Generator Transformation

Sequence Generator Transformation

Here there are multiple situations possible.

– Why are there nulls, if the attribute is a PK/FK? Sequence Generator is usually used for PK/FK or the surrogate keys. If that is the case, we need to know why there are nulls in the first place.

– If these are already set as PK/FK/SKs then how did the database load happen with out failure. If these are not set as constraints, these should be set to avoid the missing values.

– The only other case, where it is possible is when data is migrated from some other source or database which does not comply to any of the standards. For this, if its a regular process, then use use the expression transformation to identify the nulls and add a  +1 of the maximum sequence available.

Leave a Reply

Your email address will not be published. Required fields are marked *