2 points 51. An organization is moving data from various files into a data warehouse. The extracted data includes total sales by zip code. The target database requires total sales by region (ie, North, South, West, East). Which of the following transformation methods most likely will be used to transform the data to meet the requirements of the target database? Transposing. Joining. Aggregating. Sorting. 52. An account number field in a relational database table is formatted to 2 points accept a two-letter state code followed by a seven-digit customer number (for example, VA1972200). Which the following is an appropriate data type for storing the account numbers? Boolean. String. Integer Decimal