on 06-22-2010 11:24 AM
Hi Experts,
I have to migrate the data from oracle to SAP BW
Using
Oracle -10g
BODI version - Data Services XI 3.0
BW Veriosn - 7.1 MS
O/S Version - Windows XP
Unfortunately i am not able to migrate the data in the BW tables ,
the data has been loaded to BODI Intermediate Tables from Oracle.
The following checks were successful :
1. Data count and data in source matches data count and data in the BODI intermediate Table.
2. Data Type in oracle are same as for Intermediate as well as for my target tables(In SAP
BW).
3. Data count in Intermediate and Source table are equals to the data count in BW Tables but
i am not able to retrive the data in the same BW tables.
4. Connections and schema are working fine and tested successfully.
5. Its a direct column to column mapping from oracle to BW.
Can someone help me identify the steps i might have missed out in this process , also what
can be the unidentifying issues.
Please help me in resolving this issue.
Thanks in Advance
Srujan.
Edited by: srujan Kumar surampudi on Jun 22, 2010 12:25 PM
I think there are two steps which you have to do in bw side.
1 create datasouce in tcode rsa1 screen
2 create infosource to receive the the data.
Please using tcode sm59 to confirm whether your logical system for your datasource is work well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Loucas Lu,
I have already done these steps and checked the logical system connection also .
Right now I'm able to see record count in BW that is extracted from BODI.Only first colum i.e. record is having values remaining all columns contain blank values.
I hv created below structure in BW
ZPFORM - char 25 - master infoobject
ZSNPPFORM - char 25 - attribute of ZPFORM
ZSNPSPPLO - char 25 - attribute of ZPFORM
In BODI I'm using Oracle table "MST_UD_PFORM_SPPLOC_MAP" . all three fields are of VARCHAR(25) datatype in BODI.
Pls help further.
Regards,
Srujan.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.