I am using DMR and I want to create dimension Costumer (Name, Address, E-mail). But, in the data base Costumer name is free field, does not have Costumer_ID, just name, address.. which operator type in form, and I can not create dimension in DMR, because I don not have business key. Since it is free filed I can not create fake ID, because I do not know in advance all costumers.
Is there any idea how to do this.
Thanks
you can create a new column to use as businesskey. you can set it to primary key and/or unique autogenerate unique code depending on the database backend you are using.