Week 1 What is Cloud?
what stored procedure and have you familiar to write the SP's?
Download 2.55 Mb.
|
| what stored procedure and have you familiar to write the SP's?
Stored procedure is used to execute set of SQL statements at a time. Yes, based on the requirements I can mold my queries and make the sp. But the good thing we have separate data modeling team abvalible those people are handling this sp’s we will configure in our adf ingestion pipelines. what is set variable, append variable? to set the value of an existing variable we will go for this and it will replace the existing one add the new set value. The Append Variable activity to add a value to an existing array variable, it will work only for arrays and it will delete the existed one it will append the new value to existed variable. what is web activity and the web hook have you implemented? Web Activity is supported for invoking URLs that are hosted in a private virtual network as well by leveraging self-hosted integration runtime. Best example if you want to access SharePoint files from ADF we will create web activity and configure the rest of things. We thought of implementing this but doing manually as per the business users call. what is execute pipeline activity? Very imp To call the child pipeline from parent pipeline. Here parent pipeline is nothing but execute pipeline. Example for this, dimensions load is happening and facts are having dependency on the dimensions so to do this first our dimension’s pipeline will run and after that fact pipeline will trigger from my execute pipeline. what is until? It executes a set of activities in a loop until the condition associated with the activity evaluates to true. You can specify a timeout value for the until activity in Data Factory. Because if your condition didn’t met it will go on infinite loops and cost consuming. what is star schema and snowflake schema? Very imp Star Schema: Fact table depending on only one dimension is star schema. My project is design is star schema. Download 2.55 Mb. Share with your friends:
|