Enricher looking at GI table and not seeing null values : Portal

Start a new topic

Answered

Enricher looking at GI table and not seeing null values

Sam BRENNAN

started a topic almost 2 years ago

I want to create an enricher to default the date when null on an Always Authored in MDM Column on and ID Matched entity

Entity: SourceUsers

ID Matched

Initial data is populated by an integration of all SourceUsers and thatsuccessfully loads into the SD/GD table

Another Always Authored in MDM field I would like to default the date for

Field Name: SourceCreateDate
Expected: Default to Current Date

Enricher:

Filter: SourceCreateDate is null
Expression:

Expected Results:

1. Edit record and do not update the SourceCreateDate field

2. SourceCreateDate is populated with Current Date when null

3. Records save and date is in GD table.

Actual Results:

1. Edit record and do not update the SourceCreateDate field

2. SourceCreateDate is not populated

3. Enricher investigation shows that its looking at a GI table vs a SA or other table. The net result is that enricher does not work?

Thank you for your help!

Best Answer

Alexia SIMOND said over 1 year ago

Hello Sam,

If you are looking into the SA table, then I'm guessing that it is either a basic entity or a fuzzy one but for which you are processing golden via authoring.

If so, in both cases, there is no consolidation, so setting the enricher as post-consolidation will lead to the enricher not being triggered.

I would advise you to put it as pre-consolidation instead.

1 Comment

Alexia SIMOND

said over 1 year ago

Answer

Hello Sam,

If you are looking into the SA table, then I'm guessing that it is either a basic entity or a fuzzy one but for which you are processing golden via authoring.

If so, in both cases, there is no consolidation, so setting the enricher as post-consolidation will lead to the enricher not being triggered.

I would advise you to put it as pre-consolidation instead.