Combine Load & SQL Query

[Fiorrie]

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

[rubenmarin · Accepted solution]

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

[Kushal_Chawda · Accepted solution]

@Fiorrie  or you can also do

Sql_query:

SQL SELCT *...   ;

right join

LOAD *

FROM Level_Table;