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.
Inner Join not working
Moderators: chulett, rschirm, roy
Inner Join not working
prabakaran.v
Re: Inner Join not working
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
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
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 18
- Joined: Tue Dec 25, 2012 10:39 pm
- Location: Detroit,MI