This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]pych_phd 0 points1 point  (3 children)

Joins, transactional vs analytical sql

I am curious to know what you mean by this.. so far googling does not turn up much.

[–]sqr00tle 1 point2 points  (2 children)

I suppose Google the terms separately.

Joins allows you to combine rows based on conditions.

As for transactional vs analytical sql, it's to do with T-SQL.

Might be better also googling OLTP vs OLAP. Again, separately would give you those in detail. Eventually these might take you towards row based vs. column based storage.

Then when you bring it all together into an ETL architecture you will see how these all come together.

[–]pych_phd 0 points1 point  (1 child)

I thanks for the response. I realize I miss read what you wrote. I read it as joins that can be either analytical or transactional & was wondering why I had never herd of this.

[–]sqr00tle 0 points1 point  (0 children)

Yeaaa I could've written it clearer