cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to create infosource on two diff datasources?

Former Member
0 Kudos

Hi Everyone,

I have two datasources (0customer_attr,generic datasource) coming from ecc

I am using 0customer_attr datasource for customer related fields and generic for addresss related fields

1.Since the datasource structures are different Is it possible to create infosource to merge these transformations in bi 7.3 version?

2. If yes how can i create it?

Thankyou,

Kavya

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member199945
Active Contributor
0 Kudos

Hi,

Yes its possible to create info source  for 2 different source's.

refer below : Recommendations for Using InfoSources - Business Intelligence - SAP Library

you can also try with look up concept if possible : Read from DSO .

Thanks.

Former Member
0 Kudos

can u please explain how to create infosource for these two transformations from these two datasources

former_member199945
Active Contributor
0 Kudos

Hi ,

Kindly refer below document there clearly explained how to create infosource for 2 dso's same way create for 0Customer_attr.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50a29380-7adc-2e10-cfa2-fa55bcb17...

Thanks.

Former Member
0 Kudos

Hi Kavya,

You will not create Info Sources for the transformations, however for a given Info Source, you will create 2 diff transformations against 2 diff data sources....Clear?

BR,

Shreesh.

former_member976
Active Contributor
0 Kudos

Hi,

please check the Shesu refereed and we can achieve through abap routines.

former_member976
Active Contributor
0 Kudos

Hi,

my suggestion use the only data source not for the info sources

other than creating the info source write the abap logics.

Former Member
0 Kudos

Hi,

Thanks for your reply.

Just Curious to know the reason why shouldn't i use the infosource?

Former Member
0 Kudos

Hi Seshu,

I have created  infosource ,for this infosource i have created transformations with two data sources as sources

i have created transformations from infosource to target(dso)

now while creating dtp ihave two datasources so i have created two dtp's  for this datasources and loaded it to same target (DSO) .Is this approach is right?

former_member976
Active Contributor
0 Kudos

Hi,

its depends on the requirement you can use the info source or data source.

while create the info source you need to check the transfer rules and update rules and communication structure and transfer structure.

but if you create the data source we need to check only transformation form source to target.

Thanks,

Phani.