Week 1 What is Cloud?

how you are connecting with external resources in your database?

Download 2.55 Mb. Page 20/26 Date 23.09.2022 Size 2.55 Mb. #59575

Navigate this page:

• How many source systems are there in your project and what are there Very imp

how you are connecting with external resources in your database? Creates an external data source for querying using SQL Server, SQL Database, Azure Synapse Analytics, or Analytics Platform System (Parallel Data Warehouse or PDW). How many types of file formats you used as a source? Very imp Azure Data Factory supports the following file formats. Refer to each article for format-based settings. Avro format Binary format Delimited text format Excel format JSON format ORC format Parquet format XML format .csv,.txt,.xlsx and .xlsm. How many source systems are there in your project and what are there? Very imp We have four systems. There are Oracle SAP ECC SAP HANA HOB what are the types of distributions? Very imp 3 types of distributions. Hash ---> for facts Round robin by default it will take  Replicated -🡪 low volume of data tables. what is annotations? By adding annotations, you can easily filter and search for specific factory resources.  what is user properties? User properties are basically the same as annotations, except that you can only add them to pipeline activities. what is the maximum size you have loaded in your facts and dimensions? Very imp We used to get billions of records, never noticed like that but we did partitions if our file is huge. Download 2.55 Mb. Share with your friends: