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

Transformation

In BI 7.0 data flow is

Data source > Info package > PSA > DTP > Data target.

But while doing transformation, why do we use the data source to data target not PSA to data target??

Thanks

Rk..

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 07:39 AM

    Hi,

    PSA is synomymous with Data Source in BI, conceptually. It is the same structure as datasource (fields etc); it stores the data of the data source on the BI side.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      1. Why do we create the info package and load the data into the PSA. Why this extra step??

      2. Does it work as back up of data source?

      3. If both are same conceptually ..why don't SAP give the option to transform from PSA?

      One of the advantages in newer version - DTP's give you more flexibility in loading Deltas from PSA to Targets.

      Deltas can be loaded independently as DTP is Source - Target dependent - One DTP per Source - Target Combination..thus multiple DTP's - say 3 diff DTP's to load 3 ODS's

      There is no more dependency as it was 3.X a single infopackage would load deltas to say 3 ODS's ( consider a datasource feeding multiple ODS's ).

      For more

      /thread/623559 [original link is broken]

      /thread/478474 [original link is broken]

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 04:51 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 07:08 AM

    PSA is a table which stores data at the entry level - Persistent Staging Area.

    http://help.sap.com/saphelp_nw04/helpdata/en/7d/724d3caa70ea6fe10000000a114084/content.htm

    Datasource is a structure created in the source system and replicated into BI.

    In 3.X - You Assign Datasource to Infosource not PSA to Infosource.

    Transformation is a mapping btn source and target - Source may be with in BI like an ODS, Cube and Datasource which is replicated into BI from the Source System - Target may be BI object - ODS, Cube...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 12:28 PM

    Hi,

    PSA is only a staging area.

    For loading data into data targets you need transformations as well DTP's

    In transformations only you can write formulas and routines.

    Check the below links:

    http://help.sap.com/saphelp_nw70/helpdata/en/f8/7913426e48db2ce10000000a1550b0/frameset.htm

    http://help.sap.com/saphelp_nw70/helpdata/en/33/045741c0c28447e10000000a1550b0/frameset.htm

    Reg

    Pra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 08:43 AM

    Hi,

    PSA contains exact replica of data coming from datasources,and it may contain data with errors.and we cannot do transformation like TR and UR.and PSA also acts as a temporary staging area where we can do ERROR HANDLING.

    bye

    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.