DSXchange

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 am using Row generator stage to populate the data in EMP table. I have just two stage Stage1: Row generator Stage2: Oracle ( table EMP) is it possible to pass any values f...

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...