scd with oracle tables -- problem
Posted: Thu Aug 04, 2011 11:53 pm
The design for my job is as follows:
The version of datastage is 8.0.1v.
I am using oracle enterprise stage as source and reference tables.
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.
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.