The Concat() function is used to concatenate text values. It's an aggregation function, so you would typically use a GROUP by clause in a LOAD.
It's used to concatenate text values across multiple records.
If you just want to concatenate field values from the same record, use the string operator &:
FieldA & ' Text' AS NewField
I have a fact table in which I have different id's like a_Id; b_Id; c_Id and Organization
1st dim table contains a_id ; organization.... Etc
2 nd dim table contains b_Id; organization.... Etc
3 rd dim table contains c_id ; organization... Etc
So I used the auto number to remove the synthetic keys
But somehow result are not fine.
Please suggest what to do...