JDBC Producer - unable to load special characters in Oracle table properly

asked 2020-07-27 08:11:06 -0500

Sonu gravatar image

updated 2020-07-27 08:12:11 -0500

Hi,

We have 2 Oracle Tables TableA and TableB in the same database & schema and of same structure.

For a smaller section of our POC we need to move data from TableA to TableB using Streamsets JDBC Query consumenr & JDBC Producer.

The problem here is that Table A has some special characters in Column1 and the data isn't getting loaded properly from TableA.column1 to TableB.Column1.

Source and Target data after insertion look like the attached image.

I have also attached the image of data preview in streamsets which is correct.

Can you please help on this.

Thank You !!image description

edit retag flag offensive close merge delete

Comments

Unable to add images here. I have also asked same question on google groups which has attachments. https://groups.google.com/a/streamsets.com/forum/?utm_medium=email&utm_source=footer#!topic/sdc-user/g99ewcMA25g

Sonu gravatar imageSonu ( 2020-07-27 08:18:27 -0500 )edit