what is the use of validation all? To add, edit, or delete a validation rule for an attribute.
what is most common activity used in your adf Pipeline? Copy Activity, in my all-pipelines work is same and the flow also same How to migrate a SQL Server database to Azure SQL? It is common to migrate a SQL Server database to Azure SQL. We can use the SSMS’s Import and Export features for this purpose.
Azure Integration Run Time:Azure Integration Run Time can copy data between cloud data stores.
Self-Hosted Integration Run Time: Self Hosted Integration Run Time is software with essentially the same code as Azure Integration Run Time. But you install it on it on premise machine or a virtual machine in a virtual network. A Self Hosted IR can run copy activities between a public cloud data store and a data store in a private network.
Azure SSIS Integration Run Time: With SSIS Integration Run Time, you can natively execute SSIS packages in a managed environment. So when we lift and shift the SSIS packages to data factory.
Have you created self-hosted integration runtime in your project? Very imp No I never did, because there is an already pre setup in my projects. But I know how to configure. If I get a chance I used to explore it
How many IR's have you created/used in your project? Very imp We have used Autoresolve Integration runtime and self-hosted integration runtime in our project based on client requirement.
can we use self-hosted IR for data flows? Very imp No, we can’t use, because we will use data flows to perform transformation in cloud environment.
