Hi Mike, The Dimension Lookup/update transform has been created to support Type 2 Slowly changing dimensions explanation about slowly changing dimensions can be found on wikipedia <https://en.wikipedia.org/wiki/Slowly_changing_dimension>.
It indeed means you can have multiple rows for the same key, for example you would like to keep a history of address information. The date range is then also used to specify from when until when a specific row is valid. If you do not need this information you can use the "Combination Lookup/Update" <https://hop.apache.org/manual/latest/pipeline/transforms/combinationlookup.html>, this Transform will do Type 1 dimensions. Cheers, Hans On Tue, 30 Aug 2022 at 13:01, <pod...@gmx.com> 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 > > > >
