I have to populate test data in two tables EMP and DEPT.
Deptno is the FK in EMP table.
First I have populated 10 rows in DEPT table.
Initially Rowgenerator generated 10 rows in dept table with deptno from 0 to 10 and then I have updated deptno with deptno+10.
After that While generating the data in emp tables it gives error:
ORA-02291: integrity constraint
I have to populated many tables like that for test data generation.
Any sugegstion is much appreciated.
row generator
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
I am using Row generator stage to populate the data in EMP table.keshav0307 wrote:how are you populating the EMP table, spcially what is the value you are passing to Deptno column, it must be range of 10-20;
I have just two stage
Stage1: Row generator
Stage2: Oracle ( table EMP)
is it possible to pass any values for Deptno.
Whether Row generator takes car Fk constraints while populating the child table.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Is it possible in Oracle to pass any value in FK column??
NO.
so how can you pass in Dstastage....
yes you can pass any value, if you have disabled the contrant in the Table...and before enabling the constrants in table, check what are the different values in the table for deptno column, insert all those values into the DEPT table...
NO.
so how can you pass in Dstastage....
yes you can pass any value, if you have disabled the contrant in the Table...and before enabling the constrants in table, check what are the different values in the table for deptno column, insert all those values into the DEPT table...