Hi Mike, The Dimension Lookup/update transform populates Slowly Changing Dimensions, typically type 2 [1] with some additional functionality.
The "date range start", "date range end" and "version" fields are technical fields that are used to determine the validity period and version number for a dimension record. If you don't need any of the versioning information, you're probably not maintaining a slowly changing dimension. Hop comes with other transforms like "Table output", "Insert/update", "Database lookup" etc that are better suited to maintain regular tables or type 1 dimensions. [1] https://en.wikipedia.org/wiki/Slowly_changing_dimension#Type_2:_add_new_row Regards, Bart On Tue, Aug 30, 2022 at 1:01 PM <[email protected]> wrote: > > Hello! > > I try to use 'Dimension lookup/update' hop and I do not understand the > meaning of two fields in properties: > > "Date range start field / Table date range end" > > My data has no date column. I do not need it. So I cannot specify any > date. What this field is for and how to ignore it? > > > What is exactly 'Version field'? This is to keep several datasets in one > table? I.e same record can have multiple copies with different 'Version'? > What if I do no not need (most of scenarios I think) any 'versions', I > just need single copy of data? > If I have 'version number' I can leave 'key fields' empty? > > Regards, > > Mike > > > >
