Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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...