SQL Interview Questions for Freshers 1. What is SQL? SQL stands for Structured Query Language. It is the primary language to interact with databases. With the help of SQL, we can extract data from a database, modify this data and also update it whenever there is a requirement. This query language is evergreen and is widely used across industries. For example, if a company has records of all the details of their employees in the database. With the help of SQL, all of this data can be queried to find out valuable insights in a short span of time. 2. How to create a table in SQL? The command to create a table in sql is extremely simple: CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... ); We will start off by giving the keywords, CREATE TABLE, then we will give the name of the table. After that in braces, we will list out all the columns along with their datatypes. For example, if we want to create a simple employee table: CREATE TABLE ...
ASP. NET Core is an open-source an asp.net core training cross-platform that runs on Windows, Linux, and Mac to develop modern cloud-based applications including IoT apps, Web Apps, Mobile Backends, and more. It is the fastest web development framework from NodeJS, Java Servlet, PHP in raw performance, and Ruby on Rails. What is the ASP.NET Core? ASP.NET Core is not an upgraded version of ASP.NET. ASP.NET Core is completely rewriting that work with the .net Core framework. It is much faster, configurable, modular, scalable, extensible, and has cross-platform support. It can work with both .NET Core and .net framework via the .NET standard framework. It is best suitable for developing cloud-based such as web applications, mobile applications, IoT applications. What are the features provided by ASP.NET Core? Following are the core features that are provided by the ASP.NET Core Built-in supports for Dependency Injection Built-in supports for the logging framework and it c...
1. How do you remove Duplicate records in Informatica? And how many ways are there to do it? There are several ways to remove duplicates. If the source is DBMS, you can use the property in Source Qualifier to select the distinct records. Or you can also use the SQL Override to perform the same. You can use, Aggregator and select all the ports as key to get the distinct values. After you pass all the required ports to the Aggregator, select all those ports , those you need to select for de-duplication. If you want to find the duplicates based on the entire columns, select all the ports as group by key. The Mapping will look like this. You can use Sorter and use the Sort Distinct Property to get the distinct values. Configure the sorter in the following way to enable this. You can use, Expression and Filter transformation, to identify and remove duplicate if your data is sorted. If your data is not sorted, then, you may first use a sorter to sort the data and then ...
Comments
Post a Comment