Using the ETL Specification Template, complete the Blue Section titled “Source.” Follow the instructions for each column using the Book.xml file. This is the start of a Source to Target Mapping used for ETL Design. There should be a row for each attribute in the Book.xml file. Use your judgement for the definition, data type, keys, nulls, uniqueness, control values, and notes. Review the XML and JSON review for a tutorial on how to interpret XML syntax. • Data Source Name – XML Book File • Data Source Field Name – Place attribute name here. This should come from the XML tagging • Data Source Field Definition – Establish the data definition based on your interpretation. Complete this with a full sentence and example • Data Type – Establish data type. Examples: character, numeric, alphanumeric, date • Primary Key – Label Yes or No if to be used as a primary key • Foreign Key – This will be Yes or No based-on PK being Yes or No • Allow Null – Should blanks be allowed Y/N • Unique – Should field be unique Y/N • Control Values – Any definition rules to be enforced? Such as a validation list? • Notes – Any notes that would be valuable in the transformation or load step?
Don’t use plagiarized sources. Get Your Custom Essay on
Using the ETL Specification Template, complete the Blue Section titled “Source.”