It sounds like you need to define "-" as your delimiter for that specific Import Group.
When you first create your Import Group you will need to define the delimiter. Once you have done this, you can then begin to define your Dimensions - here you are defining the format of your datafile. You have a couple options here - my recommendation would be to use the Import Format Builder - it will let you drag and drop sections to define your dimension. This will get you a bit more familiar with how this works.
I would strongly recommend taking a look at the FDM Admin Guide, there is an entire section dedicated to creating an Import Group. Here is the link to the 18.104.22.168 doc - though you may be on a different version: http://docs.oracle.com/cd/E17236_01/epm.1112/fdm_admin.pdf
Hi. Thanks for the quick reply. What I am now confused about is that if I choose the delimiter as '-', then the rest of teh file is a CSV ie seperated by a comma. i preumably cannot have a '-' and a ',' as a separator in the same load file. This means that the first column has Account, C1 , entity and ICP seperated by '-' whereas the second column in teh CSV file is C2 and third clumn is C3
1 person found this helpful
You may want to look at creating an import script for this, that is the only way I could think of doing this. There is an accelerator just for this purpose, your import could be as simple as one line.
GetColEntity = DW.Utilities.fParseString(StrField,4,1,"-")
The 4 would represent the 4 columns in your string, and we are selecting the first column. StrField represents the field you have selected in the import format, and the StrRecord represents the entire line.