How to Split a File into Multiple Files In Azure Data Factory
Azure Data Factory is a data orchestration tool for ETL process. While working on moving data from source to target host, you may encounter issue with size limitations with your…
How To Open Large CSV File (2GB, 4GB, 8GB, 12GB, 50GB)
A CSV (comma-separated values) file is commonly used for data processing, data interchange and as a standard format for exchanging data between different systems or software applications. CSV format file…
How to Write Multiple Case Statement in SQL
SQL Case statement is used to compare an expression within one or more logical conditions by returning a value when if-then-else logics are used. The first is a Simple Case…
SQL QUERY TO REDUCE REDUNANCY OF DATA
What is Data Data is a collection of words, images, sound, letters and observations for analysis, reference and research purpose. What is Redundancy in Data Data redundancy is the duplication…
The difference between Artificial Intelligence, Machine Learning, Deep Learning
Artificial intelligence, machine learning and deep learning have so many published definitions. As buzzwords, their involvement in human activities is inevitable and has continued to raise concerns about its super…
Data Scientist vs Data Engineer
In a data centered world, we find a lot of job opportunities as a Data Scientist or Data Engineer for most data-driven organizations. Both career paths are data-driven, analytical and…