Questions tagged [data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
0answers
40 views

Simple alternative to a crud application?

I have a relational star database consisting of about 9 datasets - 700mb. When I connect it to powerbi / qlikview / tableau, I can slice and dice it until I get to a resulting table of values. Now I ...
0
votes
1answer
12 views

How do I select the total count of records over the past week, including days which have no records in MySQL

Essentially, I need a query which can output something like: +------------+-------+ | date | count | +------------+-------+ | 2020-09-30 | 10 | | 2020-09-29 | 3 | | 2020-09-28 | 0 | | ...
1
vote
1answer
49 views

How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?

I've created a file: 'C:\fff.txt' which contains data for my database table. Then I'm trying to load data from that file like this: LOAD DATA LOCAL INFILE 'C:\\fff.txt' INTO TABLE fff LINES TERMINATED ...
0
votes
1answer
12 views

Data sync between two local Mysql databases in different system in same netwrok

I am using mysql as database for my application and for the purpose of fail over and I need to sync the data from one local mysql database in system one to other local database in system 2 connected ...
0
votes
1answer
28 views

How to restore MySQL database files without having a MySQL instance?

After a crash of my PC I'm left with several databases (27Gb in total) that are left on my data drive, while my OS drive (Windows 7) is gone. I've reinstalled the machine by now (Windows 10) and set ...
0
votes
0answers
32 views

Oracle - SCD Type 2

I am new to Oracle I have 2 tables called dwh_tbl_dim_supplier_type2_ar (target table) stg_tbl_dim_supplier_ar (source table) dwh_tbl_dim_supplier_type2_ar contains 6 column SUPPLIER_KEY (PK) ...
3
votes
1answer
440 views

How is data lake and polyglot persistence different?

I just came across a new technology called polyglot persistence. However, it sounds very much like a data lake. So, how are these two things different?
0
votes
0answers
32 views

narrow or wide - how to store huge amount of values

I think, I have two questions maybe in one (because they belong together and the first is priorized while the second is just an idea). The leading question is: Given billions of triplets (Timestamp, ...
0
votes
0answers
11 views

Is there a way to recover a dropped database in postgresql-11

I am using postgresql-11, I have dropped by mistake the wrong database with dropdb command and I don't have any backup for it. Is it possible to recover the dropped database or the data inside it ...
0
votes
2answers
36 views

how to view data as history of field value change

Example i have data like id employeeId Salary Year 1 1 12000 2001 1 2 10000 2001 1 1 16000 2002 1 3 12000 2004 1 ...
0
votes
1answer
93 views

How do I locate my Postgres data directory while the server is down?

I'm on Mac 10.13.6. I restarted my machine and Postgres, which normally starts upon restart, wasn't running. Sadly, I cannot remember how or where I installed it. I'm able to locate instances of "...
-1
votes
1answer
41 views

SUM first consecutive rows only SQL Server

I have the following data: ROW SEGMENT ORDEN LONG 1 39 11 49.00 2 39 10 102.00 5 39 7 104.00 6 39 6 139.00 7 39 5 97.00 11 39 1 ...
0
votes
1answer
12 views

What is the safe way to update production data if data found inconsistent

I am in a small company and require to fix a bunch of data in production which are inconsistent. I have written the script to handle the fix. I understand that writing sql to fix data is way more ...
0
votes
0answers
21 views

tracking in odi the package which uses a given mapping

I am trying to find the whole lineage and loading process of a certain table column. To begin with i am locating the mapping used to populate the column. To do this i use: select m.name ...
-1
votes
2answers
42 views

Where to find Dummy Data For Oracle Database [closed]

I don't know if the question is relevant, but if someone can give me some info, I'll be very grateful. I have found this website - here for generating dummy data. I have found some .dump files full of ...
0
votes
1answer
81 views

How to fill/insert fake data into a MS Sql Server

I'm trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this I wish to fill my FILEGROUPdisk up so it will start populating the 2nd FILEGROUP. I've just created a ...
-1
votes
1answer
131 views

'PRIMARY' filegroup is full [closed]

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 ...
0
votes
1answer
53 views

MySQL date range if data not available display 0

I've a table here here is the structure : id,id_berita,ip_user,tanggal I try to use this query : select count(id) as jumlah,tanggal from tb_trafik_berita WHERE (tanggal BETWEEN '2020-01-02 00:00:00'...
-1
votes
1answer
53 views

What is the correct way to join this tables? [closed]

what is the correc way to join this tables? Party, person and organization: Tables Party: id, party_type (person/organization) Person: party_id, name, etc Organization: party_id, name, etc Other ...
0
votes
1answer
26 views

Using WHERE / AND in Joins

Can someone elaborate on how the following two queries would provide different results? That is, how the query is processed differently using WHERE or AND. select orders.*, accounts.* from ...
0
votes
0answers
775 views

Unpivot in MYSQL?

Please I need help on how I can transform the data that appears in the attached photo. Maybe Unpivot SQL?