How can I default CIM-only attributes based upon input values at import time? In other words is it possible to have conditional statements in the import mappings while importing data?

How can I default CIM-only attributes based upon input values at import time? In other words is it possible to have conditional statements in the import mappings while importing data?

book

Article ID: KB0090808

calendar_today

Updated On:

Products Versions
TIBCO Collaborative Information Manager -
Not Applicable -

Description

Resolution:
Yes that is possible.
You can have the conditional sql statements in the map field just like the hardcoded values as follows:
CASE WHEN ((@&ltDatasourceName>.&ltattributeName>) = 'Y') THEN (SUBSTR('true',1,4)) ELSE (SUBSTR(‘false’,1,5)) END.

If this is given for attribute "FLAG" then it will be assigned 'true' if the value of datasource.attributename is 'Y' else it will be assigned 'false'

And it can only take valid sql statements.

Issue/Introduction

How can I default CIM-only attributes based upon input values at import time? In other words is it possible to have conditional statements in the import mappings while importing data?
Powered by Wolken Software