Completed

A zipped folder of the entire solution

i have some work in a create Data Mart.

...

Scenario:

XYZ Corp. is a parent corporation with 2 handbag stores located in – New Jersey and New York. XYZ needs to setup a system that will gather customer data from all of the different stores and put it into one place.

Blindly copying data files from each store is not going to be good enough most of the time.

The corporation needs to have a standardized set of data in order to analyze it.

Task:

You will need to do the following:

Create a Data Mart – Create a table called: DimXYZCustomers (Create using: [login to view URL])

Build an SSIS solution to get the data from all 2 stores and load to a single data table

Review/analyze the data from all sources. Source files are on Blackboard.

Determine what needs to be standardized based on the requirements below.

The data collected should be changed to a standard format. For instance, the state value should all be 2-character value such as NY, NJ etc.

Extract data from all sources

Source file 1: [login to view URL]

Source file 2: [login to view URL]

Transform the data as follows

State – 2 character abbreviation

First and Last names – Upper case

Load to the a single data location - DimXYZCustomers

Note: custAcct will hold the PK of the source tables, however, CustomerKey is the PK of this dimension (it will auto increment)

Only good data should go to the database; bad data (assume: no account number) should go to an error log file

Add annotation to your design space

Be sure to add meaningful names to each object

Project name: LastnameFirstname_Assignment2

HINT: In addition to the objects we are familiar with, use the transformation component (can be found in the Common toolbox) – Union All

Skills: Database Administration, Database Development, Excel, MySQL, SQL

See more: compress visual studio project, how to zip a project in visual studio 2017, soursing work data entry, contract work data entry, delivery work data entry home, getafreelancer demo work data entry, setup ready work data entry karachi, scope work data mining, can better work data entry, speed need work data entry, captcha work data entry, bid online work data entry, free online job work data entre, work data entry kph 140, bid contract work data migration, goldman sachs work data entry, contract work data conversion, easy data solution work, i need a work data, a govt registered co offers you data entry form filling and paid survey work get paid on daily work online from home cyber cafe

About the Employer:
( 13 reviews ) DHAKA, Bangladesh

Project ID: #18861715

Awarded to:

hasanjack

Hi sir I am Hasan Jack and I can help you transfer you data from files to structured database and you have mentioned in you job post. Looking forward to hear from you. Best Regards, Hasan Jack

$70 AUD in 3 days
(27 Reviews)
5.5

7 freelancers are bidding on average $127 for this job

ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i am interested. Sir, i can deliver this project sooner than you expect and will be over your satisfaction level. More

$100 AUD in 1 day
(39 Reviews)
5.3
psubramonian

Hello there, I've read your serious job posting. I'm a full-time + full stack developer(Web app + Mobile Apps + .NET and so on) + support you on the job until the project delivery and forever. Also, I'm very serio More

$250 AUD in 0 days
(21 Reviews)
4.8
MaryumAkhter1

I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java, ReactJS, NodeJS) and Mobile (Native and Hybrid). I am also an expert in many differe More

$122 AUD in 3 days
(5 Reviews)
3.8
itwonder1

Hi. I have review your project description. I have full experiences in Development. I am very interested in your project and also ready to start work immediately. Hoping for your soon Reply. Thank You Regard.

$50 AUD in 3 days
(3 Reviews)
3.5
MyriadTechnology

Dear Hiring Manager, Hope you’re doing great!! I’ve carefully gone through your job posting “built a website”. We have team with experiences of Android, IOS & backend. I am very much interested in your project wit More

$100 AUD in 2 days
(0 Reviews)
0.0
CitachiTech

Hi , How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data More

$200 AUD in 3 days
(0 Reviews)
0.0