Inner Join not working

[praburaj]

Hi All,

My Source is ODBC database and my reference and target table is DB2.

In source and reference table have a column like SITE_DESC datatype is a varchar.

I have verified the data seperately in each database. Identified some common records between tehm.

But When I was doing a inner join based on SITE_DESC between these two database, none of the records are not loaded to the target table.

But in the reference table if I keep some where condition clause,then some records are loading into the target table.

I really dont know the reason why inner join condintion is not working without where clause.

Any help is really appreciated.

[SURA]

My understanding is , you are using Join in DS to Joining two columns.

What is your source data base?

Is it case sensitive?

What you are seeing in the data base canvas may not be the real truth!

May be some some unprintable characters may also create these kind of issue

[ray.wurlod]

Show us the SQL query that you are using.

A Join condition must be specified either in the FROM clause or in the WHERE clause (SQL 101).

[harishkumar.upadrasta]

Please check if the comparision is char to varchar as char padds extra spaces or pad characters which can fail the condition checks....

[ds_8112]

try using a trim() for column SITE_DESC in both your source and reference sql query