Data services: reusable query for technical attributes?

[Former Member]

Our model sports a couple of technical attributes see below.

Coming from PowerCenter where I would create a reusable expression with a dummy in-port reuniting the data paths after that.

How can I achieve this in DS?

Kind regards Thiemo

[former_member187605 · Accepted solution]

In DS, you better use global variables. When you call a built-in function in a mapping, it will be called for every record passing thru the data flow. Calling it in a script (and assigning its result to a global variable) may save you millions of function calls.

You can simply copy and paste your technical attributes from one Query transform to another.

[Former Member]

Thanks for the reply. Does that mean that there is no reusability of code at this point (Query) and Data Services does not know about its own functions to always return the same value within one run to optimize its code execution itself?

[former_member208402]

Hello Kellner,

If you want to reuse the Query transform in other jobs/dataflows, just replicate the dataflow and and change the source and target (query will be the same) or you can copy the Query (Ctrl+C) inside the dataflow and paste in other dataflow.