Table:1 CS(customer)

CS_customer_id,

CS_customer_code

CS_customer_br

Table 2 CD(costomer desciption)

CD_customer_id

CD_customer_code

can you explian me how to create check constrint??

Thanks

L

this is the error msg

The number of columns in the Primary key doesn't match with the Columns of the Foriegn key.

Please let me know...

Thanks

L

Thanks

i don't want to join tables but I want to create relation.

Is there any other way to create relation(foreing key constrain) like junction tables????

Thanks

L

Hello,

I am desinging database. and Database design

I have 2 tables.

table :1

I have 3 columns and they are composite primary key.

customer_id,

customer_code

customer_br

Table 2

I have 2 columns and they are referred to...

I am sorry ,,,,but I want to create relationship with two tables.

Means composite primary key to composite foreign key ????(it's not working)

SO how can i create relationship with table 2...

Thanks

I have used fast load in OLE DB destination and it;s very fast. It will take only 2 min.

Can i know what is exact differece between (Tables and view)

and (Table...

Thanks for replying me,

Yes,,,I have created One staging database. In This staging database, I have all 16 tables.

The thing is that ,,,,,,,i know normalization is helpful but,,,,in my case,,,,we do...

Thanks you so much...

....It's working.,..

Data will duplicate then ???

I have to create composite primary key with date?????