Target table post load command query Can we use a query joining two diff Data store tables

[Former Member]

How to use query using two differenet tables from two datastores.using a join, is it possible.

Within the query how to reference table1 from datastore1 if it is possible can someone please provide syntax.

I want to use an update statement using a multi table join, part of two data stores. in Post load command.

Thanks a lot for the helpful info.

[Former Member]

Hi,

why not just have a second dataflow running immediately afterwards?

regards,

Adrian

[Former Member]

Adrian,

If you need to refer to fields of two diff data stores can i do this?

datastore1.table1.field1 = datastore2.table2.field2

Thanks.

[Former Member]

Hi,

that is fine, just drag and drop the tables onto the DF in the GUI and set the where clause, the only word of caution is to watch the performance.  If they are large tables then it could be an issue as DS will perform a query on each datastore and join the records itself.  There are ways round this but try it and see how it performs on your data first.

regards,

Adrian