Thanks again, I didn't know that.

Here the plan: https://www.brentozar.com/pastetheplan/?id=H1PbpUEgA

The query is issued by a Databricks notebook using JDBC.

BR. Paul

Hi everyone,

thanks again for your suggestions.

Regarding the questions from @frederico_fonseca:

• what problem are you trying to solve? The customer has a complex data processing process using Azure SQL...

Hi everyone,

thanks for your support.

I'm working with a customer and I requested the actual execution plan, I can share it once I get it.

I have a query but not the...

Hi Sucharita, many thanks for this extensive and well explained article.

I had a question regarding the strategy with multiple source tables and one target table. What would be you preferred...

Hi Grant,

thanks for your answer.

I used the MSBuild.Sdk.SqlProj SDk provided here: https://github.com/rr-wfm/MSBuild.Sdk.SqlProj

With it I was able to build a database project (.sqlproj) with dotnet core.

Cheers,...

• This reply was modified 3 years, 8 months ago by  Paul Hernández.

Hi David, 
I fully agree with you. Models are the best way to communicate with business experts and also to make sure that we understand what we are doing....

Hi,

I would try to define first the most important thing, that is, the granularity and type of fact tables. Then the same for the dimensions, the grain and...

Hi, 
I guess your parameters (cost of goods and uplift factor) are related to a product or articles, which I can call dim1
I would try to handle...

Hi everyone,

thank you very much for your contributions.

At the end the key point was to figure out as you mentioned, what is intended to be aggregated, the other...

Hi Jez,

Thanks for your answer. I guess there is no single best practice that satisfies everyone.

I will use the following guidelines:

- Try to add the fact based calculations to...

Hi ebooklub,

I find somehow funny that companies are looking (at least here in Germany) senior big data architects, data engineers and developers with AT LEAST 5 years of experience in...

Hi David, thanks for the explanation.

It is what I wanted to say but in a understandable way.

Hi,

I read this in the article:

Today, many have outlined the differentiating line as to how Cloudera and Hortonwork look at data warehouses, asserting that Hortonworks is willing to support...

I think as part of the digital transformation, enterprise big data providers must include the customer feedback in their business models and product development process, and they already do that,...

Hi, I am right now in a similar situation.

I don't know if someone already mentioned it, but there are really good ways to get started. I would choose either, the...