Problem while using LookUp stage and Join Stage
Posted: Wed Sep 16, 2009 12:48 pm
Hi
I have some problem when I use the LookUp Stage and Join stage. Following are the details:
Source Oracle 10, target: Oracle 10.
Im extracting data from 1 oracle table using an ODBC stage, then i use a look up stage to look up with another table (i use ODBCstage).
in target i need to take S.col1, S.col2, L.col2
when i apply this condition inthe look up stage i get a error
Then I tried to use a join stage. I used hash partition and sorted on the key column. Now i got a different out put.
in this row 1 and row3 are correct but row 2 should have a value and not 0. im able to get this if i run the query in oracle.,
i do not get any warning message apart from NLS warning message. Can anybody help me to fix this. right now im using oracle to query to insert into the table and that works fine, but i need to implement this in DS.
I have some problem when I use the LookUp Stage and Join stage. Following are the details:
Source Oracle 10, target: Oracle 10.
Im extracting data from 1 oracle table using an ODBC stage, then i use a look up stage to look up with another table (i use ODBCstage).
im joining based on col1. data type is varchar2(10).Source query:
select S.col1, S.col2 from source_table
Lookup query
select L.col1, L.col2 from look_up_table
in target i need to take S.col1, S.col2, L.col2
when i apply this condition inthe look up stage i get a error
but i tried to write a query in oracle and i was able to pulle all the requied rows. I used trim function to trim the columns, still no go."Lookup_166,1: Failed a keylookup for record."
Then I tried to use a join stage. I used hash partition and sorted on the key column. Now i got a different out put.
Code: Select all
col1 col2 l.col2
1 v 100
2 u 0
3 w 101
i do not get any warning message apart from NLS warning message. Can anybody help me to fix this. right now im using oracle to query to insert into the table and that works fine, but i need to implement this in DS.