Hi All
Where can I see a list of what "Functions" are available when creating a projection mapping rule, and how to use the functions?
I am trying to create a mapping rule in the Replication Flow whereby a target column gets the first 6 characters of a particular source column.
So when creating a Replication Flow, in the Projection section of the target object I have clicked on "Add".
On the "Mapping" page, I have added a new column (string 6) and ticked the box under "Functions / Constants". In the text box I was then expecting to be able to type LEFT(field1,6) so that I can map the first 6 characters of field 1 to the new field.
But on clicking deploy, I get an error message suggesting the length of the value is 14 when expecting only 6. I have worked out that the system is counting the length of the text "LEFT(field1,6)" - ie. the system is seeing my mapping rule as a Constant and not a Function.
How do I get the mapping rule to use a Function? Or am I trying to do something that's not possible and the "Functions / Constants" description in the mapping section is misleading?
I realise I could create another table that includes the new field and update accordingly in a transformation flow, but I was hoping to do such mappings at load time to the replication flow target to avoid duplicating data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.