sushanth bobby
Active User
Joined: 29 Jul 2008
Posts: 263
Location: INDIA
|
|
|
|
Hi,
I have a doubt in loading tables. This is how it goes.
Table1 = Parent table
Columns= ID,c1,c2,c3
Primary key = ID
Table2 = Child table
Columns=ID,tab1,c4,c5,c6
Primary Key = ID
foreign key =tab1 referencing table1
Doubts,
While loading the table2, there are few records which are not in the table1.
a)What will happen(will table go into pending states)
b)Is there a possibility of loading table2 with orphan records(no parent)
Sushanth |
|
