Let’s have a look on some specific common differences that are mostly used on day to day work in Salesforce.

1. Data Loader Vs Data Import Wizard

Data Loader Data Import Wizard
Data Loader can handle upto 5lacs of records Data Import Wizard handles upto 50 thousand number of records.
It does not able to catch duplicates It catches duplicates
It also allows to export data. There is no option available to export data.
We can import opportunities through data loader We can’t import opportunities here.
It’s a tool that require to setup in locale It exists within the Salesforce org.
The option of hard delete is available in data loader There is no option of hard delete available.
There is no option to turn off workflows here, so we need to turn off workflow through setup Yes,there is no option to turn off workflows here

2. Managed Vs Unmanaged Package

Managed Package Unmanaged Package
Managed packages are used by Salesforce partners for distributing and selling applications to their customers. Unmanaged packages are used for distributing an open-source projects or application templates to provide developers with the basic building blocks for an application.
For managed package, the components installed can not be edited in the organization they are installed in. For an unmanaged package, the components installed can be edited in the organization they are installed in.
Using the AppExchange and the License Management Application (LMA), developers can sell and manage user-based licenses to the app. Managed packages are also fully upgradeable. The developer who created and uploaded the unmanaged package has no control over the installed components, and can’t change or upgrade them.

3. Workflow Vs Process Builder

Workflow Process Builder
You can only achieve four actions through workflow Here we have an option to choose 9 actions to perform through process builder.
Actions are as follows : Create Task Update Field Email Alert Outbound Message Actions are as follows : Call apex methods Create a record Send an email Launch a flow Post to Chatter Call An Invocable Process Quick action to create a record, update a record, or log a call Submit for approval Update related record

4. Standard Report Types Vs Custom Report Types

Standard Report Types Custom Report Types
Build report based on common standard object relationship. Build report based on different combination of related objects
Build with reports Build with or without report
Includes all standard and custom fields for each object in report builder. Limit, reorganize and rename the fields available in report builder.

5. Workflows Vs Triggers

Workflow Trigger
It’s an automated process that fired an action based upon an evaluation criteria and rule criteria. It’s a piece of code that executes before or after a record is inserted or updated.
We can access a workflow across the object. We can access the trigger across the object and related to that objects
We cannot perform DML operation on workflow We can use 20 DML operations in one trigger.
We cannot query from database We can use 20 SOQL’s from data base in one trigger.

6. SOQL Vs SOSL

SOQL SOSL
Salesforce Object Query Language Salesforce Object Search Language
SOQL can only query one object and related objects at a time SOSL enables you to search text, email, and phone fields for multiple objects simultaneously.
SOQL queries used in triggers SOSL queries can not used in triggers
Use SOQL when you want to retrieve data from number, date, or checkbox fields. Use SOSL when you want to retrieve data for a particular division in an organization using the divisions feature, and you want to find it in the most efficient way possible.
Data can be retrieved by using ‘SELECT’ keyword Data can be retrieved by using ‘FIND’ keyword
SOQL Limits : Total number of SOQL queries issued in synchronous mode is 100 Total number of SOQL queries issued in asynchronous mode is 200 Records retrieved by SOQL queries is 50,000 SOSL Limits : Total number of SOSL queries issued is 20 Records retrieved by SOSL queries is 2000.
For example : SELECT Id,Name,(SELECT Id FROM Contacts WHERE Active__c = true) FROM Account For Example : [FIND ‘Dinesh*’ IN ALL FIELDS RETURNING Account (Id, Name), Contact (Id, Name), Opportunity (Id, Name)]

Thanks For Reading!!

Happy Salesforce!!