Hello , can you tell me how do I create and introduce an analytic function in the mapping canvas?
Is there any particular operator for this?
I know the code I want to use but I don't know how to because I am doing everything for first time. Thank you very much.
The attribute's expression uses the analytic function, for example COUNT(*) OVER (PARTITION BY COLUMN)
The attribute's datatype is dependent on the function and input datatype, mostly numeric/numbers. You should just define expressions referencing the functions in OWB, you shouldn't need to wrapper in any function - for this case.