how to connect the two different schemas

[#1]

I have two different data base star schemas are their with common columns  . I want to merge the two schemas into one schema how to do. plz tell me any one.....

[chriscammers]

You definitely need to provide more information but if as you say there are "Common columns" between the two facts then I would suggest concatenating the fact table and using the dimensions only once.

Without some detail of what your are doing I cannot say with any certainty what you should do.

[ajaykumar1]

Hi ,

Try like this.

//ODBC/OLEDB path;

Table1:

SQL SELECT "Country Code",

    "Country Name",

    "Currency",

    "Customer Name"

FROM Schema1.dbo.new1;

Store Table1 into D:\qvds\Schema1.QVD;

drop table Table1;

Table2:

SQL SELECT "Country Code",

    "Country Name",

    "Currency",

    "Customer Name"

FROM Schema2.dbo.new2;

Store Table2 into D:\qvds\Schema2.QVD;

drop table Table2;

Final:

load Country Code,

    Country Name,

    Currency,

    Customer Name

    from D:\qvds\Schema1.QVD(qvd);

    Concatenate

load Country Code,

    Country Name,

    Currency,

    Customer Name

    from D:\qvds\Schema2.QVD(qvd);

    store Final into D:\qvds\Finaldata.qvd;

    drop table Final;

Regards,

Ajay

[#4]

both schemas had common columns between fact tables and dimension tables

[Anonymous]

you need to follow this way:

Dim1:

Load *

From Schema1;

Concatenate(Dim1)

Load *

From Schema2;

do these for all dimension and fact tables