Skip to Content

Embedded Data Flow

    An embedded dataflow is a dataflow that is invoked within another data flow. Data passes into or out of the embedded dataflow from the parent flow through a single source or target. The embedded dataflow can contain any number of sources or targets, but only one input or one output can pass data to or from the parent data flow.

 

Use embedded data flows to:

  • Reuse dataflow logic: Save logical sections of a dataflow so you can use the exact logic in other data flows, or provide an easy way to replicate the logic and modify it for other flows.
  • Simplify dataflow display: Group sections of a dataflow in embedded data flows to allow clearer layout and documentation.
  • Debug dataflow logic: Replicate sections of a dataflow as embedded data flows so you can execute them independently.

Following steps explains the creation of embedded dataflow.

Step 1: Create a flow to extract the count of source and job id. Then select the required objects and right click and choose option “Make Embedded Dataflow” and name the reusable object. The reusable dataflow will be available now in the dataflow tab in the object library.

Step 2: Drag and drop this reusable embedded dataflow wherever required.

3 Comments
You must be Logged on to comment or reply to a post.
  • Hi Radhika,

    It was nicee topic. I need one help from your side. Can you please let me know how to call stored procedure in data services?

    2) how to use  SQL function in Script level ? can you please explain one example?

    3) How to write try- catch block and explain one example?

    let  me know ..