Ranjana Admin

How To Start Your Career As MSBI Developer?

MSBI is a powerful business intelligence tool that helps to overcome all IT issues at pocket-friendly prices. It is considered as the best option among all BI tools available so far. The wide adoption of the tool by leading industries is one of the major reasons why MSBI is a lucrative career choice for learners…

Answered Jan 17, 2022 · 500 Views Read answer →

How To Start Your Career As MSBI Developer?

MSBI is a powerful business intelligence tool that helps to overcome all IT issues at pocket-friendly prices. It is considered as the best option among all BI tools available so far. The wide adoption of the tool by leading industries is one of the major reasons why MSBI is a lucrative career choice for learners…

Answered Jan 17, 2022 · 100 Views Read answer →

Why Non-Clustered Index takes much longer to create than clustered Index?

Create Clustered Index When you create a clustered index, you are actually sorting the data in the table in the order of the clustered index you are creating. They are not ~a copy~ of the table, they are the table, ordered by the column(s) you choose as the key. It could be one. It could be a few. It could be a GUID!…

SQL Server

Answered Oct 14, 2021 · 2.2K Views Read answer →

How can I take backup of particular tables in SQL Server 2008 using T-SQL Script

Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial SQL Server database or individual files or filegroups of the database. Table-level backup cannot be created, there is no such option. But there is a workaround for this Taking backup of SQL Server table…

Salesforce

Answered Aug 26, 2021 · 1.2K Views Read answer →

Search while Type functionality on VFP not working as expected between apex: tab transition

The "AJAX" type switch mode results in a round-trip to the server and the DOM is regenerated. This wipes out any changes that may have been made to the DOM by the client since the last update. Change the switchType attribute to "client." Self-contained example follows. function filter() { var searchTerm =…

Salesforce

Answered Aug 12, 2021 · 893 Views Read answer →

What is the Black Tab?

This is a tab available only to Salesforce employees, primarily higher tier support I believe, that they use to enable/disable specific features or adjust limits in customer orgs. Some of the functionality that can be enabled/disabled according to that blog: Enable API for PE orgs Disable auto-number fields from being…

Salesforce

Answered Aug 8, 2021 · 1.7K Views Read answer →

What is hadoop namenode format? and Why is it used?

Hadoop NameNode is the centralized place of an HDFS file system which keeps the directory tree of all files in the file system, and it tracks where across the cluster the file data is kept. In short, it keeps the metadata related to datanodes. When we format namenode it formats the meta-data related to data-nodes, and…

Big Data Hadoop

Answered Jul 27, 2021 · 3.7K Views Read answer →

MySQL Query GROUP BY day / month / year

Try this code to solve sql group by day: GROUP BY YEAR(Record_date), MONTH(Record_date) OR You can use DATE_FORMAT operator. If you are using this you can easily group the date, timestamp or datetime column using whatever format you want. Example: If you want to group rows that were added on the same day. Use this…

Data Science

Answered Jul 15, 2021 · 3.5K Views Read answer →

Which of the following statements about data analytics and visualization is false?

The correct answer is option B (It is easier to make sense of data than it is to collect the data). Handling real data is a big mess since there can a lot of missing data and outliers. Cleaning the data and bringing useful insights from the data is a lot tougher than collecting the data.

Python

Answered Jul 13, 2021 · 851 Views Read answer →

`Git: How to update/checkout a single file from remote origin master?

It can be done in the deployed repository: $ git fetchThe git fetch command will download all the recent changes, but it will not put it in your current checked out code (working area). $ git checkout origin/master -- path/to/fileThen the checkout command will update the working tree with the particular file from the…

Data Science

Answered Jul 8, 2021 · 2.1K Views Read answer →

Git push to different remote - Git push existing repo to a new and different remote repo server?

To solve git push to different remote, you need to copy the repo to your git-hub and work on it for that follow the steps: Create a new repository in your github Then clone the repository which you need to work on from your hosted.org to the local machine Then rename the repo with upstream using: git remote rename…

Devops

Answered Jul 1, 2021 · 1.2K Views Read answer →

python socket.error: [Errno 98] Address already in use

There is obviously another process of listening on the port. You might find out that process by using the following command: $ lsof -i :8000or change your tornado app's port. tornado's error info not Explicitly on this.

Python

Answered Jun 30, 2021 · 7.4K Views Read answer →