Skip to Content
avatar image
Utkarsh Bhan

Can we get the information of all the Tables, columns and there Data type from the SQL transform?

Jun 20, 2017 at 08:32 PM | 37 Views

Dear Experts,

In our setup, we use SQL transform to extract data from the Source Application. Now for an ongoing migration project, we are required to provide the information for all the Source side tables (there columns and data type) that we being used. I have tried options such as Auto-Documentation feature of DS MC, explored the possibility of using metadata info. but so far haven't been able to meet the requirement.

I would really appreciate if you can help me to figure out a way here.

Thanks,

UB

SAP Data Services
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Dirk Venken
    Jun 21, 2017 at 09:05 AM

    Check my blog

    Let the database do the hard work! Better performance in SAP Data Services thanks to full SQL-Pushdown, and more particularly the comment I posted on 18 Feb 2014:

    "

    In, general, I do not recommend the use of SQL-transforms to our customers. Why would you want to hand-code something yourself that can be automatically generated by the tool?

    Also, with SQL-transform as a source, DS cannot generate a full SQL-pushdown anymore. It will have to pull all data in memory before writing out to the target, not good for performance with high data volumes.

    On top of that, it will break lineage and impact analysis functionality. Making your application maintenance more complex.

    "

    Add comment
    10|10000 characters needed characters exceeded