SQL transform vs. Query

[system]

120×120 10.4 KB

Approach: DataServices is so limited when it comes to the sql syntax supported in Queries, I do not want to read all data from a table, I want to use variables to read just a subset Solution: I use a SQL Transform everywhere Problem with that: A SQL Transform has lots of limitations, no impact lineage information, no partitioned readers, hard to read & modify the SQL statements typed, no full pushdown in the sense of an insert…select…, etc. And actually it is not needed. DataServices has an o…

---

Werner Daehn (BOB member since 2004-12-17)