Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Query to display duplicate records without using group by
Use self-join to compare records
Select records where the values match but the primary key is different
Example: SELECT a.* FROM table a, table b WHERE a.value = b.value AND a.id <> b.id
The 'FOR XML' command is used in SQL Server to generate XML output from a query result.
It allows transforming the result set of a query into XML format.
It can be used to generate XML documents for data exchange or integration purposes.
The 'FOR XML' command supports different modes like RAW, AUTO, EXPLICIT, and PATH.
It can be combined with other SQL Server features like joins, aggregations, and subqueries.
Example: SELEC
stuff() replaces a specified number of characters with another string, while substring() extracts a portion of a string.
stuff() is used to replace a specified number of characters in a string with another string.
substring() is used to extract a portion of a string based on the starting and ending index.
stuff() can be used to mask sensitive data in a string, such as credit card numbers.
substring() can be used to extract...
Transaction property in SSIS ensures all tasks in a package are completed or rolled back as a single unit.
Transaction property is used to ensure data consistency in a package
If a task fails, all previous tasks are rolled back
If all tasks complete successfully, they are committed as a single unit
Transaction property can be set at package or container level
Supported isolation levels are Serializable, Repeatable Read, Rea
The connection string can be passed on runtime using various methods.
One way is to use a configuration file and read the connection string from it.
Another way is to pass the connection string as a parameter to the application.
The connection string can also be stored in a database and retrieved at runtime.
Using environment variables is also a common method to pass connection strings.
Connection strings can be encrypted a...
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.
I applied via Referral and was interviewed before Jul 2021. There were 2 interview rounds.
I applied via Recruitment Consultant
I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.
Standard Coding questing
I applied via Referral and was interviewed in Jan 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Challenges faced while migrating reports from one environment to another
Compatibility issues between the old and new environments
Data source connections may need to be updated
Formatting and layout may need to be adjusted
Security settings may need to be reconfigured
Testing and validation of migrated reports is crucial
User training may be required for any changes in functionality
based on 1 review
Rating in categories
Application Development Analyst
39k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
27.4k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
Team Lead
24.7k
salaries
| ₹7.1 L/yr - ₹25.5 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹20 L/yr |
Senior Analyst
17.8k
salaries
| ₹5.5 L/yr - ₹21.3 L/yr |
TCS
Cognizant
Capgemini
Infosys