SQL transform issue in data services

[former_member451049]

Hi Folks,

I am using SQL transform in data services, Here when i am using the query in hana getting complete records. The same query i kept in sql transform and loading in stg table without any filters. But few records are missing when loading in stg table..

Please share your thoughts.

Thanks,

Chandra

[former_member451049]

its due to data type issue.. i converted to char its working fine

[former_member198401]

Check the table access rights associated with the Datastore user which you are using to connect to SAP HANA Database. This might be due to restrictions on the user

Regards

Arun Sasi

[Former Member]

Please check if you have any of the below challenges.

1. If any filter being applied in SQL Transform or in Query transform.

2. Check if the database of the staging table is not full.