Skip to Content
0

SQL transform issue in data services

Jul 24, 2017 at 02:19 PM

62

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Jul 24, 2017 at 02:34 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jul 25, 2017 at 05:29 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 22, 2017 at 01:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded