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
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.
"