Can you tell me if there is a limit for the transform and cleanse?
Welcome back to the Community.
No limitations in the software that I am aware of, except to say that the configuration of the workstation where TDP is installed is probably the biggest factor... e.g. the more memory/horse-power, the better.
Otherwise, we'll need more specifics regarding what you mean by limitations.
My experience is the same as Gary. Transform and Cleanse is great, but speed will be limited by how your local system is configured. We tend to create our calculations directly in the SQL if they are very large or complex. I would say 80% of what we do uses Transform and Cleanse, and 20% calculations directly in the query.