I found that while using funel and change capture stage.
Funel stage requires all sources have the same column definition, but even I defined the same columns in datastage for all connectors, it still throws an error that the actual tables have different column definitions.
And so is the change capture stage. If I use
it always throws an errorchange mode=Explicit Keys, All Values
But if I use"A field cannot be both a key and a value"
, it runs ok. And I guess that's because the stage can't tell the value fields or retrieves the wrong information from the connector.change mode=Explicit Keys & Values
And I still found that: only the informix connector causes the problem for change capture stage. The ODBC connector, oracle connector doesn't (I guess it can't retrieve information from the API or due to some other thoughts), and DB2 connector doesn't because it would retrieve the right info.
And, all I want to know is that How to prevent datastage jobs from retrieving source info, no matter the connector is informix,oracle or db2 or any other type.
Thanks all