In a lookup enricher is there a way to tell: 'Do nothing' in fallback value because my output will be NULL instead of a previous value? Also what are the limits of the SQL Custom parameter that would make the enricher not work ? Thanks in advance
Best Answer
S
Stéphanie Fourrier
said
about 2 years ago
The options for Behavior on Error include skips the current record, skips the entire task, or stops the whole job.
If you want to know if you can put any custom Sql query as complex as it is with LOOKUP_COLUM and output_column1, then the answer is yes, you should be able to use any custom function in the Lookup_Column
1 Comment
S
Stéphanie Fourrier
said
about 2 years ago
Answer
The options for Behavior on Error include skips the current record, skips the entire task, or stops the whole job.
If you want to know if you can put any custom Sql query as complex as it is with LOOKUP_COLUM and output_column1, then the answer is yes, you should be able to use any custom function in the Lookup_Column
Stéphanie Fourrier
In a lookup enricher is there a way to tell: 'Do nothing' in fallback value because my output will be NULL instead of a previous value? Also what are the limits of the SQL Custom parameter that would make the enricher not work ? Thanks in advance
The options for Behavior on Error include skips the current record, skips the entire task, or stops the whole job.
If you want to know if you can put any custom Sql query as complex as it is with LOOKUP_COLUM and output_column1, then the answer is yes, you should be able to use any custom function in the Lookup_Column
Stéphanie Fourrier
The options for Behavior on Error include skips the current record, skips the entire task, or stops the whole job.
If you want to know if you can put any custom Sql query as complex as it is with LOOKUP_COLUM and output_column1, then the answer is yes, you should be able to use any custom function in the Lookup_Column
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 252 topics