u/SnooCalculations1882

Hi Guys,
ive be been working with sql and databases ever since i fell into the category of accidental dba, so roughly 3 years. I have never worked on design of databases. i leterally got dumped with the instances and databases and they said keep it up :)

My situation is as follows and im looking for any advice or pointers for real world scenarios that you guys have dealt with.

The company get data fails (xlsx, csv, txt...) dropped from various vendors onto ftp. The data team then grab these files and through SSIS transform it from DIM tables to the final production database tables.

My question is how is the best way to approach this. Is it database per vendor that gives us data and then transform to a production database.
or 1 database for staging with different schemas per vendor, then move that to a production site?

I just dont know, id love to hear the suggestions or options. All our SQL instances are currently on premise

Hi Guys,
ive be been working with sql and databases ever since i fell into the category of accidental dba, so roughly 3 years. I have never worked on design of databases. i leterally got dumped with the instances and databases and they said keep it up :)

My situation is as follows and im looking for any advice or pointers for real world scenarios that you guys have dealt with.

The company get data fails (xlsx, csv, txt...) dropped from various vendors onto ftp. The data team then grab these files and through SSIS transform it from DIM tables to the final production database tables.

My question is how is the best way to approach this. Is it database per vendor that gives us data and then transform to a production database.
or 1 database for staging with different schemas per vendor, then move that to a production site?

I just dont know, id love to hear the suggestions or options. All our SQL instances are currently on premise

So there is teacher, not to be so indirect, but has natural padding, and padding on top of that. She get to school between 6 and 7 AM, opens gate to go in in and closes it cause kids not allowed in. Some kids in shorts and lucky if jersey and she turns blind eye. I know parents have to drop kids early to get to work, but God, have a heart if that person must be there and they are a few mins early.

Sad part is teacher acts like it's normal