Combining 3 fields from different tables into 1 field in fact table
I'm having trouble figuring out a problem. Here's the situation... I have two fields (Date and State) in my Fact Table and then another field (Zip Code) that is in another table connected to the Fact Table (Zip Code is not the field from its table that is put into the Fact Table). Basically, what I want to do is create a field in the fact table that combines all 3 fields. Example: 20140301Texas75201 (Date&State&Zip Code).
This will help me create a unique identifier for some data that I'm bringing in from a CSV file to connect to my Fact Table. Any thoughts? I think a combination of ApplyMap and Concatenate should solve the problem... but I'm not exactly sure how to execute.