Questions about data-warehouse
Read more about data-warehouse
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Efficient way to update a table in Data ware house which is used for reporting
We have a data ware house running on PostgreSQl, the database size is of 1.5TB.
We are using DROP & RECREATE logic on all our scripts to update the tables and use it for our reporting.Our data lay...
Sandeep
Votes: 0
Answers: 0
Is it ok to have 2 dimensions that are the same but one is less deep?
I have a fact table, with account number and some numbers associated..
I have my DimAccount which has a very long hierarchy of level1,sub-level2… up to sub-level20.
When reporting in PowerBI this make...
Chicago1988
Votes: 0
Answers: 1
joins supported in sharded MongoDB Atlas cluster
I'm trying to evaluate MongoDB Atlas on GCP, and had a few basic questions regarding joins.
What the different types of joins supported ?
Are these joins supported in a sharded cluster as well ?
I s...
Karan Alang
Votes: 0
Answers: 0
UDP packet receive errors continuously increasing while using logstash udp input and some filters and output to a PostgreSQL database
Here I am processing massive logs that are originated from a router, and sending it to logstash which is receiving logs via UDP input method. Having some filter methods to it and finally inserting tho...
bhuwan pandit
Votes: 0
Answers: 1