Multiple Join condition

[system]

Hi,

I want to have multiple join conditions(Inner join) in one query.

Can this be acheived through Query transform or SQL transform.

And also explain the difference between these two transformations.

Thnx,
Vinoth.

---

weknowd (BOB member since 2011-03-23)

[system]

Yes, this can be done in both the query transform (modify the where clause) and the SQL transform (specify the SQL code).

Generally, best practise dictates that you only use the SQL transform when you’ve run out of other options.

---

Nemesis (BOB member since 2004-06-09)

[system]

Things you should never do - a collection and discussion

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)