Data Factory Join Transformation showing Null Values instead matching records

Question

I am joining two different tables using Azure Data Factory with Data Flow Activity.

In Data Flow Activity I am using Join Function For joining two tables with column having same Values.

While joining these columns the output is returning as null for one of the in put table and as well it is not showing any matching records in between them.

The Table which i am trying to join other table returning null in data preview of join even if you inner join or left outer join.

This will be joining two tables with Left outer join

This will be joining two tables with inner join

This will be the output of matching table in the data preview just showing null values.

When i see the projection of matching table it has values.

Can someone help me to resolve this issue please.

Answer 1

It seems you want to match 1 with 01 and because data types differ, the join operation may not produce the desired results. I suggest to use internal functions to convert to same data type and after converting the data types of both streams to target format, you can use the Join transformation in your Azure Data Factory Data Flow to perform the join operation. Ensure that you select the appropriate join type (e.g., inner join, left join, etc.) based on your requirements.

Answer 2

Hi
Hemanath Goud Kandula,

Thanks for providing the information.

For Oracle as Source in Data Flow Activity, it is currently not supported in ADF.

For list of connectors and support refer to https://learn.microsoft.com/en-us/azure/data-factory/connector-overview

Currently Oracle is supported with Copy Activity as Source/Sink and in Lookup Activity.

For this, I would recommend you to share your valuable feedback for this feature enablement over Azure Data Factory Feedback Channel where concerned team will look into the requests and prioritize on the basis of importance and up-votes.

As a workaround, consider using Copy Activity https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory to take data to Azure and then use Data Flow activity.

Hope this helps. Please let us know if you have further queries.

Thank you.