Question:
Dear All
After successful Load of an ODS ,a characteristic in the same ODS is having the SID values as ONE instead of 1000. As I want the unique count of this characteristic. Could you please suggest me abt the same.
Thankyou
ymg
Answer:
You surely mean characteristic value? An ODS is a flat table, and I think only each request is assigned a SID in the system. SID for char. values are used only in star schemas.
If you characterisitc is alphanumeric (instead of numeric), you may need to look at the conversion exit, whether it has ALPHA or none. If it has no conv. exit then that's probably why '1000' is inserted as '1'. This could lead to conflicts with characteristics that have the value '1'. But with ALPHA, '1000' will be, for example, '001000' and 1 witl be '000001', thus each retaining it's unique value.
Is this what your problem is?
_________________
Keep smiling