Skip to Content
author's profile photo Former Member
Former Member

Doubt in Dataflow in BI

1.I have one doubt that

my Existing Proces chain flow goes this way....

Two Datasources A & B connected to one infocube C

start -----> Infopackage for DS A --------->Infopackage for DS B ---------> Delete Index for Cube C ---------> Execute DTP for DS A---------> Create Index Cube C --------> Compress Cube C ----------> Delete Index for Cube C ---------> Execute DTP for DS B---------> Create Index Cube C --------> Compress Cube C.

This flow comes in Straight not in branches,

My Suggested flow is

start -----> Infopackage for DS A --------->Infopackage for DS B ---------> Delete Index for Cube C ---------> Execute DTP for DS A---------> Execute DTP for DS B---------> Create Index Cube C --------> Compress Cube C.

Please guide me if i am going wrong.

2. Which comes first? Compression or Creating Index.

3. Existing Data flow from Datasource to cube flows in this way

Datasource -------> Transformation---------> Infosource--------> Transformation----------> Cube

My Suggested flow is

Datasource -------> Transformation----------> Cube

Please suggest me If i am going wrong as it is very important to me.

Thanks in Advance

which should comes first

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2012 at 10:19 AM

    Dear Vijaykumar,

    1. The flow that you have suggested, you can use provided that the flows doesn't have dependancy on each other.

    2. Create Index will come first

    3. I am unclear on this point. Is it 3.x flow. If yes then you have to just trigger infopackage and DTP cannot be triggered to load from infosource to target. Please clarify on this point. If the same flow is which you are going to modify then clear the flow first.

    Regards,

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2012 at 10:31 AM

    Hi,

    1. If the data sources A and B doesnot have any dependency, then you can have your flow as:

    start -----> Infopackage for DS A (and) --------->Infopackage for DS B ---------> Delete Index for Cube C ---------> Execute DTP for DS A---------> Execute DTP for DS B---------> Create Index Cube C --------> Compress Cube C.

    (Info packages A an B can run in a single step, you dont want to wait for A to complete to trigger B)

    If you have dependencies in the data source, then execute them pne after another.

    2. Generally, the flow in 7.x would be

    Datasource -------> Transformation----------> Cube

    But there are some exceptions, where we will be placing Info sources between PSA and Target to achieve some calculations or data for few fields through routines. Please check that, if everything is direct mapping, then you can go with normal flow. If not you have to place the info source inbetween.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.