I have an Oracle stage with only one column ID(Decimal 15) and i am looking up on ID in another Oracle stage with 3 columns ID(decimal 15), DATE(decimal 15) and DW_ID(decimal 15). Then the data is loaded into the target table.
The lookup has no condition and the lookup failure condition is set to DROP.
The job runs successfully but i am getting NULL values for all records for the DATE column, while the values for ID and DW_ID column are correct.
I checked for 1 ID value in target table to that in the reference table and found that the corresponding DATE value is non null.
How can i fetch correct values for DATE column? What might be the problem?
Getting nulls after lookup stage even after key column match
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Mon Jun 18, 2007 5:11 am
- Location: Mysore
have an Oracle stage with only one column ID(Decimal 15) and
As u said i think the Oracle stage with 3 colums is taken as lookup, thats why you r getting null values
Thanks and Regards
patil
patil
Re: have an Oracle stage with only one column ID(Decimal 15)
Apply proper partetion before take lookup and check once again another small question, the datatype of data field is DATE or TIMESTAMP, You posted this date field with datatype Decimal 15,patil.bnk wrote:As u said i think the Oracle stage with 3 colums is taken as lookup, thats why you r getting null values
I think other than lookup fields are having null values.
venki
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia