A15LL

docx

School

Lamar University *

*We aren’t endorsed by this school

Course

5360

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by LieutenantEchidna3210

Question 1: What is a DataSource? A data source refers to the configuration that links a server to a database and defines the location of the database tables. Question 2: You have created a DataSource for sales data. What do you think is the destination of this data in terms of the Snowflake Schema? Why? Transactional data in the form of sales data has been generated and is ready to be incorporated into the fact table. Question 3: Go to the Data Preview and toggle the Show data in internal format only flag. Comment on the Revenue formats when you toggle. There is no comma separator between numbers. Question 4: What is the Internal format for salesdate? The form is RSDAT which converts the date from external to internal format. Question 5: Take a screenshot of your data preview of the DE DataSource. Question 6: What are the differences between US data as compared to the data from Germany? Germany and the U.S. require the creation of two distinct sets of data sources due to dissimilarities in the data. Question 7: Why did you have to create two DataSources, one for DE and one for US? Two different data sources must be created for Germany. And the U.S because the data itself is different. Question 8: What is the Unit of Measure of Sales Quantity? The unit of measure of sales quantity is five with the format as internal. Question 9: Are any Characteristics mapped to the DataSource fields yet? Why? Why not? No, they are not mapped because we are only looking at extraction and not doing transformations yet. Question 10: How many sales transactions do you have in the US? How many for DE? U.S sales: 84,194.

DE sales: 86,816 Question 11: Insert a screenshot of the data preview from your US DataSource. Question 12: Insert a screenshot of your DataSources In your Application Component

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

A15LL

Related Documents