Hi @Partha Das ,
Conditional split transformation can be used when you want to split incoming rows as separate streams based on conditions and process them accordingly. Whereas Assert Transformation can be used when you want to perform data validation on the incoming rows.
Let's assume you have employee data coming in with different department Ids and want to split those rows based on departments and process each department related rows separately and load them into different tables. In this case you can use conditional split transformation. Please check below video where with an example I explained about conditional split transformation.
Conditional Split Transformation in Mapping Data Flow in Azure data factory
Let's assume if you want to validate incoming rows and check for data quality you can consider using assert transformation. In below video, I explain usage of assert transformation with some examples for better understanding. Kindly check same.
Assert Transformation in Mapping Data Flows in Azure Data Factory
Hope this helps. Please let me know if any further queries.
Please consider hitting
Accept Answer and
Up-Vote. Accepted answers help community as well.