Add office photos
Filter interviews by
CompuCom Datastage Developer Interview Questions and Answers
CompuCom Datastage Developer Interview Experiences
1 interview found
(5 Questions)
- Q1. Basic of etl, sql, unix
- Q2. What is etl and it works, architecture, connectivity
- Ans.
ETL stands for Extract, Transform, Load. It is a process of extracting data from various sources, transforming it, and loading it into a target database or data warehouse.
ETL is used to integrate data from multiple sources into a single, consistent format.
The Extract phase involves retrieving data from source systems such as databases, files, or APIs.
The Transform phase involves cleaning, filtering, and manipulating th...
- Q3. Join inner outer functions
- Ans.
Join inner outer functions are used in Datastage to combine data from multiple sources based on a common key.
Join function is used to combine rows from two or more tables based on a common key.
Inner join returns only the matching rows from both tables.
Outer join returns all the rows from both tables, including unmatched rows.
Examples: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN.
- Q4. Unix commands script basics
- Q5. College project
Skills evaluated in this interview
Interview questions from similar companies
Coding test is medium level with graphs tree array
It was a little bit tough
(1 Question)
- Q1. About you current position
(1 Question)
- Q1. Regarding you experience in IT
(1 Question)
- Q1. Salary negotiation
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about ur self
- Q2. And some sql queries and questions
Interview Preparation Tips
(1 Question)
- Q1. Few questions about powercenter
Coding test is medium level with graphs tree array
It was a little bit tough
DBA Administrator Interview Questions & Answers
Bounteous x Accolite
Anonymous
posted on 13 Apr 2023
Selected
I applied via Naukri.com and was interviewed in Oct 2022. There were 2 interview rounds.
(3 Questions)
- Q1. What is replication
- Ans.
Replication is the process of copying and distributing data from one database to another.
Replication is used to improve data availability and increase scalability.
It can be done in real-time or on a schedule.
There are different types of replication, such as snapshot replication, transactional replication, and merge replication.
Examples of replication software include Oracle GoldenGate, Microsoft SQL Server Replication,
- Q2. What is upgradation
- Ans.
Upgradation refers to the process of upgrading or updating a system or software to a newer version or better quality.
Upgradation involves replacing an older version of a system or software with a newer version.
It can also involve adding new features or improving the existing ones.
Upgradation is important to ensure that the system or software remains secure and compatible with other systems.
Examples of upgradation inclu...
- Q3. What is backup and recovery
- Ans.
Backup and recovery is the process of creating and restoring data in case of data loss or corruption.
Backup involves creating a copy of data to protect against data loss or corruption.
Recovery involves restoring the data from the backup in case of data loss or corruption.
There are different types of backups such as full, incremental, and differential backups.
Backup and recovery is important for ensuring business contin...
Skills evaluated in this interview
CompuCom Interview FAQs
Tell us how to improve this page.
CompuCom Interviews By Designations
- CompuCom Network Engineer Interview Questions
- CompuCom Desktop Support Engineer L1 Interview Questions
- CompuCom Apprentice Interview Questions
- CompuCom Contracts Development Manager Interview Questions
- CompuCom Datastage Developer Interview Questions
- CompuCom EDI Analyst Interview Questions
- CompuCom Infrastructure Engineer Interview Questions
- CompuCom IT and System Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- ETL Developer Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Informatica Developer Interview Questions
- Lead Data Engineer Interview Questions
- Data Architect Interview Questions
- Show more
Interview Questions from Similar Companies
|
Technical Support Engineer
122
salaries
|  ₹2.7 L/yr - ₹5.8 L/yr |
|
Senior Software Engineer
94
salaries
| ₹8 L/yr - ₹29.2 L/yr |
|
Network Engineer
90
salaries
| ₹3 L/yr - ₹5.9 L/yr |
|
Technical Lead
74
salaries
| ₹12 L/yr - ₹32 L/yr |
|
System Administrator
62
salaries
| ₹3.8 L/yr - ₹15.4 L/yr |
Wipro
HCLTech
Tech Mahindra
Infosys
Calculate your in-hand salary
- Home >
- Interviews >
- CompuCom Interview Questions >
- CompuCom Datastage Developer Interview Questions
