Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDS DATA Expand / Collapse
Author
Message
Posted Friday, February 1, 2013 12:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
Hi all,
I think this may be a basic question.But still i'm not clear about this..
If i'm using Master Data Services(MDS) for master data storage,In transaction database how i able to give relationship between transaction table and master data .
so i need to have master data in both MDS as well in Transaction DB am i right?
correct me if i'm wrong.



thanks
Post #1414466
Posted Friday, February 1, 2013 7:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 PM
Points: 7,094, Visits: 12,579
sathiyan00 (2/1/2013)
Hi all,
I think this may be a basic question.But still i'm not clear about this..
If i'm using Master Data Services(MDS) for master data storage,In transaction database how i able to give relationship between transaction table and master data .
so i need to have master data in both MDS as well in Transaction DB am i right?
correct me if i'm wrong.



thanks

What did you mean by that statement? Are you asking about foreign keys? Or about keeping data in sync? Or something else.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1414662
Posted Sunday, February 3, 2013 10:12 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
foreign key...
Post #1415101
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse