Skip to Content
avatar image
Former Member

Data Lineage Model using PowerDesigner

Hello Experts

I am new to Power Designer and my task at my work place is to create Data Lineage Model using Power Designer. I was hoping if you can assist me to begin with

1. How can i create a Data Lineage Model using Power Designer?

2. Is there any document template to document the data flow?

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2015 at 09:52 AM

    Hello Praveen

    You have a couple of choices - using the Mapping Editor to links source models to target models (which is straightforward), or creating a Data Movement Model (more complicated). If the you take the first option, you can move on to the second one later.

    To help us help you, can you please outline what Data Lineage you need to capture. Do you, for example, want to map source data to a data warehouse?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2015 at 01:43 PM

    Hi Praven,

    just right click an object on the diagram for example. Select "Impact and lineage analysis" in the following dialog you may

    choose "Generate Diagram"

    In the data movment model, create a "transformation process" , right click that process and add a "transformation task" and close

    the dialog.

    By right clicking the "transformation process" and selecting open diagram, you may define the task by "ETL" tools.

    Rgds, Andreas

    Add comment
    10|10000 characters needed characters exceeded