DSXchange

I'm trying to compose a JSON file using the input data coming from Netezza Database. In the output JSON file I've to put some of the fields inside an array into two different objects. Input Fields: (I just mentioned the fields which should insert into an array) PROD_CATG_CODE_PRE_1 RPT_BRAND_GROUP_P...

Hi All! My job design looks like the below. Dataset->T/R -->Db2-->(Rejectlink)Dataset. Write Mode-->Insert Table action-->Append For the testing purpose we are processing some duplicate records and trying to collect the rejected records which are not able to insert in the DB2 table. RCP is enabled b...

Hi!
I am not able to understand why it throws error like 'Update prepare failure'. Are you using it as a target?

Then, coming to RDMS stage you should create a ODBC connection first.

Hi!
You can send anyone of the values(0 or 4 or 5) through a parameter.
Do you want to send all the values at a time?

Please check the columns list in your source file.

Hi!

Make sure that your fields are in same order for before and after links..

Hi Vijay! As per my understanding you are struggling at the first join whenever it displayed left record and right record. You can send the both left and right records and put a transformer after the join and write a condition like if the left record is null then populate the right one otherwise lef...