interview questions on data loader

        Q. What is upsert in salesforce ?
  • Upsert means to update the record while inserting the record in Salesforce.
  • Upsert = Update + Insert
  • Q.  Can we avoid duplicates using apex data loader which we can do through import wizard?
  • No.
       Q. What is difference between “Export” and “Export All” in apex data loader?
           Export: It will fetch only active records from salesforce.
           Export All: It will fetch active as well as records from recycle bin.
         

        Q. Can We Bypass The Required Fields In Data Loader?

      Ans: Inserting the records through Data loader Required fields cannot be skipped. If you have           Required fields in your object make sure you have values in the CSV for those fields as well. There is no      setting to by bass the required field check. although you can turn off the validation rules simply uncheck the   Active check box.
    Q.Hard Delete Not Working In Apex Data Loader?

Ans: Check your Profile permissions  “Bulk API Hard Delete” check box should be enable  for permanently deleting the records using Apex Data Loader. Using Hard Delete operation, we can delete existing records from our Salesforce organization permanently. Deleted records will not be available in Recycle Bin.
Bulk_API_Hard_Delete

    Q.How To Start Loading Data From 101 Row Of The CSV File In Data Loader?

Ans: Open your data loader then Menu section Go to Settings–>scroll down  and Set “Start at Row” field to start the process from the 101 row number from the CSV file.

   Q.How Can We Bypass Workflow Rules When Using The Data Loader?

Ans: We don’t have any option to skip workflow rules,Validation rules and Triggers from data loader.But we can deactivate the workflow rules while loading data through data loader. But it’s not a good practice,why because that the workflow can be deactivated in the app before using the Data Loader, but users can be creating/editing records during this process which should not be interrupted

Q.How To Import MultiSelect Picklist Values Through Data Loader?

Ans:  By using apex data loader inserting or updating multi select pick list fields through the Apex Data Loader, multiple values for the mulit picklist field are separated by a semi-colon “;”.

Q.How To Import Different Languages Data Into Salesforce?

Ans: Follow the below simple steps to import different languages data using Apex Data loader.

  1. Open the .xls file that displays the other language characters correctly and which was prepared for import.
  2. Click File –> Save As. In “Save as type”, kindly select Unicode Text (*.txt).
  3. Click “Save” button.
  4. Open the .txt file in Notepad.
  5. In Notepad, click File –> Save As, In“File name”, change the file’s extension from .txt to .csv. “Save as type”, select “All Files”, In “Encoding”, select “UTF-8”, Click “Save” button.
  6. Import the .csv file.

Q.How To Skip Triggers And Validation Rules From Apex Data Loader?

Ans: We can skip the trigger and Validations rules while loading the data through data loader Manually deactivating and activating trigger and Validations. But We are having large number of triggers andvalidation rules in our salesforce production org. We also do manual dataloader operation frequently.It is time consuming and on top of that it also affects live production users. It’s not a good practice
 It would be really good if dataloader can provide facility to skip triggers and validation rules ( e.g. to provide checkbox to skip ) while running dataloader operation.


For Inserting records into data loader?

Step 1: Click on the insert button and login with your credentials and provide “your org password + security token”.

Step 2: Click on NEXT 

Select the object you want to insert the records and choose the .csv file you want to upload.

Note: Data loader allow only .csv files.

Step 3: Map the fields using drag and drop features.

Step 4: Click on ok or save the mapping

Step 5: Click on NEXT and then click on Finish. 

After inserting the records it will display error files and success files.

Comments

Post a Comment

Popular posts from this blog

Security model

Image
  Salesforce provides a robust and flexible data security model to secure data at different levels. It also provides a sharing mechanism to open up access securely based on business need. Organization level security For your whole org, you can maintain a list of authorized users, set password policies, and limit logins to certain hours and locations. Login IP Ranges  – Login IP Ranges defines a set of IP ranges, so a user with that profile can only log in from that set of IP ranges. If the user tries to log in outside that range, the user would be simply kicked out. There is always confusion between trusted IP ranges and login IP ranges. The difference is, using trusted IP ranges, users can log in outside the trusted IP range with verification method, whereas with login IP range, there is no way to log in outside login IP range . Login Hours – It allows us to set login and log out time-based on the day for users with the profile. You can set time daily in a week. With the help of Login
Read more

EVENTS IN Lightning Web Components

Events in Lightning web components (LWC) | Communicate with Events In this post we will talk about how to use the lightning web component events to communicate between components. Events in Lightning web components are built on DOM Events, a collection of APIs and objects available in every browser. Here we will be see how to the events using the CustomEvent interface and publish-subscribe utility. COMPONENT COMMUNICATION THROUGH EVENTS There are typically 3 approaches for communication between the components using events. Communication using Method in LWC ( Parent to Child ) Custom Event Communication in Lightning Web Component (Child to Parent ) Publish Subscriber model in Lightning Web Component ( Two components which doesn't have a direct relation )  1) COMMUNICATION USING METHOD IN LWC (PARENT TO CHILD) In Aura framework, we can call the method of Child Component from the Parent Component with the help of <aura:method> . In LWC also we can do the same. In LWC Aura Method
Read more

Lightning web Components.

 Lightning Web Components:-  Lightning web components are leverages  new web standards  and allows developers to create web components which  can work in Salesforce Lightning platform. It is new programing model to create lightning components. Lightning Web components are custom HTML elements built using HTML and modern java script ES6+. Lightning Web Components uses core Web Components standards and provides only what's necessary to perform well in browsers supported by Salesforce. Lightning Web Components are lightweight and delivers exceptional performance. Because its built on code that runs natively in browsers. All the key elements  to create component are part of native web browser engine and you don't need any framework to create these components. These are based on modern web standards and It enhance and make use of custom elements, templates ,decorators, Shadow DOM, various modules in ECMAScript7.
Read more