AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
UST
Compare
Filter interviews by
UST SQL Ssis Developer Interview Questions and Answers
UST SQL Ssis Developer Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Aug 2023. There was 1 interview round.
(2 Questions)
- Q1. How to use pivot in SQL server
- Ans.
Pivot in SQL server is used to transform rows into columns, based on a specified column value.
Pivot is used to rotate rows into columns
It requires an aggregate function to be applied on the values being pivoted
The PIVOT operator is used in conjunction with the SELECT statement
The PIVOT operator requires a unique identifier column and one or more columns to pivot
The PIVOT operator can be used to perform dynamic pivoting
- Q2. Two files have different sets of columns in a file how to manage this in ssis
- Ans.
In SSIS, you can manage different sets of columns in two files by using conditional splits and dynamic column mapping.
Use a conditional split transformation to separate the data flow based on the file type or column presence
Create separate data flows for each file type and handle the columns accordingly
Use dynamic column mapping to map the columns dynamically based on the file type
You can use expressions and variables ...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
SQL Developer Interview Questions & Answers
Virtusa Consulting Services
Manshi
posted on 13 Jun 2024
Simple coding not that much tough
(2 Questions)
- Q1. Question related to your skills
- Q2. Just basic questions
(1 Question)
- Q1. Why u want to join
SHOW TIME
Performance tunning and sql profiler
SQL Developer Interview Questions & Answers
Sutherland Global Services
Anonymous
posted on 13 Jun 2024
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
Profit and loss,percentage
(2 Questions)
- Q1. Why do you this job ?
- Q2. How can i believe you are the best to our company?
Interview Preparation Tips
ABHISHEK BOORUGU
(1 Question)
- Q1. Qquestions about your skills
Asked question from basic aptitude topics
(1 Question)
- Q1. Asked question coding languages like c, python, java, SQL
(1 Question)
- Q1. Discussed about terms and policies of company. Also work profile
Interview Preparation Tips
SQL Developer Interview Questions & Answers
Virtusa Consulting Services
Anonymous
posted on 15 May 2023
Selected
I applied via Campus Placement and was interviewed before May 2022. There were 4 interview rounds.
General aptitude and English questions you can crack it with basic knowledge
(2 Questions)
- Q1. Asked about sql,python,java
- Q2. Oops concepts and basic sql quarries
(1 Question)
- Q1. General hr questions about strengths and weaknesses and relocation
SQL Database Administrator Interview Questions & Answers
DXC Technology
Saikiran Katukuri
posted on 11 Sep 2021
I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. General questions
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.
SQL queries on different logical problems
(1 Question)
- Q1. Basic concepts of SQL
Interview Preparation Tips
UST Interview FAQs
Tell us how to improve this page.
UST Interviews By Designations
- UST Software Developer Interview Questions
- UST Senior Software Engineer Interview Questions
- UST Software Engineer Interview Questions
- UST Devops Engineer Interview Questions
- UST Java Developer Interview Questions
- UST Validation Engineer Interview Questions
- UST Team Lead Interview Questions
- UST Associate Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Ssis Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- SQL and PL SQL Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
UST SQL Ssis Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Developer
2.1k
salaries
|  ₹2.5 L/yr - ₹12.7 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹6.5 L/yr - ₹27 L/yr |
|
Software Engineer
1.3k
salaries
| ₹3.6 L/yr - ₹15.1 L/yr |
|
System Analyst
1.2k
salaries
| ₹6.4 L/yr - ₹22.2 L/yr |
|
Senior Software Developer
941
salaries
| ₹5.6 L/yr - ₹20 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- UST Interview Questions >
- UST SQL Ssis Developer Interview Questions
