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
Configuring Generic stage for Change capture operator
Moderators: chulett, rschirm, roy
Re: Configuring Generic stage for Change capture operator
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.
Before Data--->CE(joining keys)--->CE(value keys)--->CDC--->CI-->target DS.
Re: Configuring Generic stage for Change capture operator
Thanks for the input , the design worked.
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
Re: Configuring Generic stage for Change capture operator
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,
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,
Cheers,
prem
prem