Data Factory Join Transformation showing Null Values instead matching records

Hemanath Goud Kandula 1 Reputation point
2023-05-29T16:21:19.3666667+00:00

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 joining two table with left outer join

This will be joining two tables with inner joinScreenshot 2023-05-29 121156

This will be the output of matching table in the data preview just showing null values.Screenshot 2023-05-29 121357

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

Screenshot 2023-05-29 122017

Can someone help me to resolve this issue please.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,539 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 17,875 Reputation points
    2023-05-29T18:26:54.2233333+00:00

    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.

    1 person found this answer helpful.
    0 comments
  2. ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
    2023-06-05T09:26:30.4633333+00:00

    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.

    0 comments