topic Re: Combine Load & SQL Query in App Development

Combine Load & SQL Query

Fiorrie — Fri, 30 Jul 2021 07:01:48 GMT

Hi Everyone

I am trying to connect Load and SQL Statement after I drop the table (so not using concatenate as I am not using star scheme in this case). I want to connect additional dimension to existing model through ID. Can you advise please?

Many thanks

Re: Combine Load & SQL Query

rubenmarin — Sun, 01 Aug 2021 07:08:00 GMT

Hi, sometimes you can load directly from SQL but I always set a LOAD before, so maybe to do a join you must use a load?:

Left Join LOAD *; SQL SELECT...

Re: Combine Load & SQL Query

Kushal_Chawda — Sun, 01 Aug 2021 13:48:28 GMT

@Fiorrie or you can also do

Sql_query:

SQL SELCT *... ;

right join

LOAD *

FROM Level_Table;