A16SHS

.docx

School

Lamar University *

*We aren’t endorsed by this school

Course

5360

Subject

Information Systems

Date

May 9, 2024

Type

docx

Pages

5

Uploaded by HighnessDoveMaster921 on coursehero.com

Question 1: Insert a screenshot of your aDSO showing the added InfoObjects. Ans: Question 2: What is the difference between a field and an InfoObject? Ans: A field is where adaptable applications are produced whereas information object is that are coordinated and fit across the whole association. Question 3: What is the advantage of using InfoObjects instead of fields in an aDSO? Ans: Info Objects data are shared with the whole organization. On the other hand, field is only one of the table's field. We can only know the client's name or number from a field. Whereas an info object holds detail data of the client.
Question 4: Insert a screenshot of your Data Flow and label each box with the type of object it is (not the name). Ans: GG1DM181 Sales Data Source GG1DSDE181 (File) Data Source GG1DSUS181 (File) Data Source File Source System Question 5: Why did you choose Direct Assignment for Customer? Ans: I have chosen direct assignment because I’ll just take the source data and feed it directly into the target. Question 6: Can one Source object be mapped to multiple Target objects? Provide an example. Ans: Yes, one source object can be mapped to multiple target objects. Such as, sales data is connected to sales organization, calendar day, year, and month. Question 7: Why does the Cost of Goods Manufactured not need a Currency Key? Ans: As the currency is fixed to be in USD so the Cost of Goods Manufactured not needed a Currency Key.
Question 8: What will be the final Currency of Net Sales? Ans: The final currency of Net Sales is Euro and USD. Question 9: Explain, in detail, the Transformation Rule for Sales Organization. Ans: The customer will be assigned to appropriate sales organization depending on the sales date. Question 10: Why does the Sales Data a DSO need two transformations? Ans: Two transformations are required for the Sales Data aDSO because there is one for US and the other for EU sales data. Question 11: Why is order number a field and not an InfoObject? Ans: The order number is only a single digit without any specific meaning. As it is not detailed information, it is classified as a field. Question 12: Why did you have to execute two DTPs? Ans: I had to execute two DTPs because there are two transformation (US and EU data sources). Question 13: What would happen if you executed a DTP twice by mistake? Ans: If I have executed a DTP twice by mistake the system could have failed to check and double the key figures which results in doubling of all revenue and sales quantity. Question 14: What is the Source object of the DTP? Ans: The source object of DTP is Data Source. Question 15: What is the Target object of the DTP? Ans: The target object of the DTP is aDSO Question 16: In the context of the Snowflake Schema, what type of data are you loading with these DTP? Ans: In the context of the Snowflake Schema, I am loading with these DTP is Sales Data.
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