what is source and what is sink? Copy activity depends on source and sink concept. Source is nothing but where our data gets residing(cloud/vm/on-premises). Sink is nothing but our target where are we going to designate our data finally.
what is activity? To perform an action, we need an activity. Activity is nothing but one processing step in pipeline.
What is Pipeline? Pipeline is logical group of activities which will perform unit of task.
How Pipeline works? Very imp Pipeline connect the source and collect the information and perform the transformation then store in data Base.
What is Integration Runtime? Very imp The Integration Runtime is the compute infrastructure used by Azure Data factory.
what is ETL and ELT? Very imp ETL stands for Extract, Transform and Load while ELT stands for Extract, Load, Transform. ETL loads data first into the staging server and then into the target system whereas ELT loads data directly into the target system.
ETL: we will use ETL for Relational Data base and Small and medium size of business
Example: SQL server ELT:IT used for bid data analytics Example: Facebook and twitter what are the types of activities there in adf? There are two types of activities that you can use in an Azure Data Factory pipeline.
Data movement activities to move data between supported source and sink data stores.
Data transformation activities to transform data using compute services such as Azure HDInsight, Azure Batch, and Azure Machine Learning.
what is json code? what exactly it will tell you? Output code which is generated by adf.
JSON is short for JavaScript Object Notation, and is a way to store information in an organized, easy-to-access manner. In azure we are getting this is as a output for all the activities.
