Issue while converting 2.9.2 graph to compile with 2.1

CloverDX Platform
1

Hi ,

Thanks Agata for your help on the last post. Due to some constraints I wont be able to use the new version 2.9.2 … so I need to change the transformation graphs created by the new tool to compile with older version 2.1 . I have some old version graphs to help me but I am stuck on the following error -

[java] Checking graph failed! (Field name specified as a key doesn’t exist: source_id)
[java] EXT_MERGE_JOIN0 …FATAL ERROR !
[java] java.lang.RuntimeException: Field name specified as a key doesn’t exist: source_id

Source

Does version 2.1 support ExtMergeJoin ? … how can I resolve the above issue ?

Thanks,
Ashish

2

Hello,
the message means, that field source_id doesn’t exist in an input metadata. Your joinKey should probaly have form $source_id(a)#$product_id(a);, ie $masterKey#$slaveKey

3

Hi ,

I removed the $ and # from $SOURCE_CODE#$SOURCE_CODE and changed it to SOURCE_CODE=SOURCE_CODE

Now I able to make the new version graphs work with the older version :smiley: but I still have some questions about modifications I made …

I was trying to use the OracleDataWriter component and the sqlldr utility failed with older version so I used DBOutputTable

Does OracleDataWriter work with older version ?
and the graphs are running slower with the older version … :frowning:

Thanks
Ashish

4

Hello Ashish,
OracleDataWriter exists since 2.2 CloverETL version and it’s a lot of faster then DBOutputTable (see comparison in DataDirect’s OracleDB JDBC driver speed test).