DSXchange

Hi,
We are developing a generic job with change capture functionality incorporated using a generic stage since the number of change values keep varying at runtime and these change_value columns are to be passed as a single parameter seperated by commas.

How to specify the option name and option value in the generic stage for this specific scenario.

Note: We have given the following,
operator = changecapture
OptionName = Key
optionvalue = <FieldName>
OptionName = value
optionvalue = <parameter> # parameter contains the column1,column2 seperated by comma
optionname=keepCopy
optionname=keepEdit
optionname=keepDelete
optionname=keepInsert

Execution Results
With the above options, we are getting the below error
Fatal Error:
Generic_11: When processing argument -valueWhen processing name: column1,column2 is not a valid field selector: Expected identifier, got: column1,column2
How to fix this issue

The other way you can work to create a generic job for CDC is using the two column export stage one for join keys and another for value keys. you need to use the schema file,which has to be passed in the column export stage. For you scenario you can create two schema files for joining keys and value keys. probably the part of design will be like this

Before Data--->CE(joining keys)--->CE(value keys)--->CDC--->CI-->target DS.

Thanks for the input , the design worked.

Hi Sir,

Could you please explain elaborately about the below design. For CDC we need two input links....

Below is your flow,

BeforeData --> CE(keys) --> CE (Value) --> CDC --> CI --> target DS

Thanks,

The user who posted that has not posted since 2012...