The version of datastage is 8.0.1v.
Code: Select all
Oracle Enterprise stage
|
| Reference link
Primary link |
Source table----------------------SCD---------------------------dataset
Oracle Enterprise stage | Output link
| Dim changes link
|
Peek stage
The column list for reference link is sno, eno, ename, salary in which sno is surrogate key, eno is business key, ename and salary are type 1 attributes.
The metadata for the columns is ( sno: decimal[38] ,eno: decimal[38] , ename : varchar[50], salary : decimal[10,2])
The column list for source link is eno, ename ,salary.
Both metadata are same and I imported from table definitions.
The problem I am facing is :
Example records:
Reference Table:
1, 6789, kiran,1000
2,6790, raj, 10000
source table:
6789, kirankumar, 1000
567, somu, 19990
The expected output of scd stage is
1, 6789, kirankumar, 1000
3, 567, somu, 19990
But the output i am getting is
1, NULL, kirankumar, 1000
3, 567, somu, 19990
I am getting Null for the matching business key. Even when I view data from oracle enterprise stage I am viewing the data as expected.
I used sequential files as input but got the expected result.
Is there anything I missed.
This runs fine when i replace the oracle table with sequential files.