Skip to Content

SQL transform issue in data services

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2017 at 05:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2017 at 01:38 PM

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

    Add comment
    10|10000 characters needed characters exceeded