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

Load infocube with 2 Infopackages

Hello Experts ,

I have a question, can you load data from 2infopackages into one infocube?

If yes how?can you please explain me.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2012 at 02:16 PM

    Hi,

    If you have more than one transformation on same info cube then you use more than one info package. If data is extracting from 2 data sources in to same target then there may be chances of multiple IP’s.

    Thanks

    Riyez

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 25, 2012 at 02:22 PM

    Hi,

    Yes, single cube can be loaded from different Infopackages. We can create multiple update rules for each IP and load to same cube

    If DTPs are used, we can create multiple DTPs, transformations and then start loading to the cube.

    Consider the scenario where the data is coming from different source systems. In this case, we will be creating separate Datasources and start data loading

    Regards
    Chandu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2012 at 01:23 AM

    Hi,

    Yes, If a cube is loading from 2 diff datasources then obviously it will have multiple infopackages and dtps.

    The best practice is the maintain two infopackages for the 1 datasource one for full load and another for delta load....

    Regards,

    Aravind.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 02:23 AM

    Hi Sheela,

    Info Package is one to many or one to one. You can load data from one source to one target or from one source to different target.

    If you want to load data from different sources to same target, create update rules for required update rules from source to target.

    Say you have item data in one DS and schedules data in one DS. using two different IP's and update rules you can load this data to same Info Cube.

    If you want to load data from one source to many taregt, then no need to create multiple IP's. In IP display --> targets tab -->here we can add multiple targets to one Info Package.

    When it comes to DTP(data transfer process), this is always one to one

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 08:48 AM

    Hi sheela

    Yes ofcourse you can load data from multiple sources into a cube.

    suppose you have n objects organised under the cube, all the objects might not be available in a single data source.

    so you just have to track the source and create transformations and dtps individually for different sources with the same cube and trigger.

    Sources can be from same or different source systems

    Regards 'sujay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 07:34 AM

    Hello Guys thanks for your quick responses.

    I want to load data from 2 datasources to 1 target,Could you guys please tell me the steps how to join these 2 datasources and sent into a target.

    iam very confused of joining these datasources to 1target,do we use infosource in between,pls guys help me out with steps how the dataflows till target.

    Pls very urgent Yaar.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sheela,

      Either create a DSO in between

      You can create a DSO in between the Cube and the Datasources. You can load data from 2 datasources to the DSO, once all the data has been moved you can go ahead and move the data from DSO to the cube.

      Or create 2 Cubes and a Infoset / Multi provider according to your requirement

      You can create two cubes, load the data individually into the cubes, then either create Multi or Infoset according to your requirement. If you require UNION then go for Multi and if you require Joins then create infoset.

      Please let me know in case you require any further information or clarifications.

      Let me know if I could be of help.

      Regards,

      Sankalp Sawhney

  • author's profile photo Former Member
    Former Member
    Posted on Apr 27, 2012 at 06:40 AM

    Thanku Guys for your valuable answers.

    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.