Question Re: Data services: reusable query for technical attributes? in Technology Q&A

Data services: reusable query for technical attributes?

Former Member — Wed, 21 Mar 2018 15:32:55 GMT

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

Re: Data services: reusable query for technical attributes?

former_member187605 — Thu, 22 Mar 2018 08:20:20 GMT

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.

Re: Data services: reusable query for technical attributes?

Former Member — Thu, 22 Mar 2018 18:48:43 GMT

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?

Re: Data services: reusable query for technical attributes?

Former Member — Fri, 23 Mar 2018 08:58:11 GMT

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.