AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
HCLTech
Compare
Filter interviews by
HCLTech Datastage Developer Interview Questions and Answers
5 Interview questions
Yes, you can send attachments in DataStage using email notifications or external scripts.
Use the DataStage job properties to configure email notifications.
Utilize the 'Email' stage to send emails with attachments.
Integrate with external scripts (e.g., Python, Shell) to handle file attachments.
Example: In the Email stage, specify the attachment path in the 'Attachments' field.
To get reject records in DataStage, use filters and stages like Transformer to identify and separate invalid data.
Use a Transformer Stage: Implement a Transformer stage to apply conditional logic that identifies records that do not meet specific criteria.
Filter Stage: Utilize a Filter stage to exclude valid records based on defined conditions, allowing only reject records to pass through.
Stage Variables: Create st...
Use sed command to display the line before a specific pattern
Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern
Replace 'pattern' with the specific pattern you are looking for
This command will display the line before the pattern in the file
Join is used to combine rows from two or more tables based on a related column, while lookup is used to retrieve data from a reference table based on a matching key.
Join combines rows from multiple tables based on a related column
Lookup retrieves data from a reference table based on a matching key
Join can result in duplicate rows if there are multiple matches, while lookup returns only the first matching row
Join i...
What people are saying about HCLTech
Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.
Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)
Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)
Fact table is typically normalized, while dimension table is denormalized for faster queries
Fact table is usually larger...
HCLTech Datastage Developer Interview Experiences
3 interviews found
Anonymous
(3 Questions)
- Q1. Difference between join and lookup
- Q2. Diffrence between fact table and dimension table
- Ans.
Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.
Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)
Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)
Fact table is typically normalized, while dimension table is denormalized for faster queries
Fact table is usually larger in s...
- Q3. Sed command to display last before line
- Ans.
Use sed command to display the line before a specific pattern
Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern
Replace 'pattern' with the specific pattern you are looking for
This command will display the line before the pattern in the file
Skills evaluated in this interview
HCLTech HR Interview Questions
- Q1. What is the most complex job you worked in your career?
- Q2. Can you send an attachment in Datastage, if yes how?
- Ans.
Yes, you can send attachments in DataStage using email notifications or external scripts.
Use the DataStage job properties to configure email notifications.
Utilize the 'Email' stage to send emails with attachments.
Integrate with external scripts (e.g., Python, Shell) to handle file attachments.
Example: In the Email stage, specify the attachment path in the 'Attachments' field.
- Q3. How to get reject records without using lookup/merge?
- Ans.
To get reject records in DataStage, use filters and stages like Transformer to identify and separate invalid data.
Use a Transformer Stage: Implement a Transformer stage to apply conditional logic that identifies records that do not meet specific criteria.
Filter Stage: Utilize a Filter stage to exclude valid records based on defined conditions, allowing only reject records to pass through.
Stage Variables: Create stage v...
Mamata Raut
(1 Question)
- Q1. Basic of etl process, sql, unix
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Mostly scenario based questions according to domain i got insurance based questions
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Tell me about your work experience
- Q2. It's answer change according to projects you worked on
Datastage Developer Interview Questions & Answers
IBM
Neeraj Ramesh Deshbhratar
posted on 13 Nov 2021
I applied via Naukri.com and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Your total experience is 6+ in SQL and SSIS, but your relevant experience in Datastage is 3+, and already you are on a higher package as compared with 3 years Datastage developer, we might tak a pause here...
- Ans.
My experience in SQL and SSIS has prepared me well for Datastage development. I am confident in my ability to quickly learn and excel in this role.
My experience in SQL and SSIS has given me a strong foundation in data integration and ETL processes.
I have already demonstrated my ability to learn quickly and adapt to new technologies, as evidenced by my success in my current role.
I am eager to expand my skillset and take...
Interview Preparation Tips
Nishok Parama
Selected
I appeared for an interview before Aug 2022.
(2 Questions)
- Q1. Basic questions about datastage Like difference between lookup,merge,join Questions with dataset and sequential stage. Then few questions asked on transformer stage.
- Q2. Remove duplicate using datastage
- Ans.
Use Datastage to remove duplicates from a dataset
Use a Remove Duplicates stage in Datastage to eliminate duplicate records
Configure the Remove Duplicates stage to identify and remove duplicates based on specific key columns
Ensure that the dataset is sorted properly before applying the Remove Duplicates stage
(1 Question)
- Q1. In second round most they focused on scenario based questions in both datastage and SQL.
(1 Question)
- Q1. Salary and location discussion
Selected
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. Explain transformer stage
- Ans.
Transformer stage is a Datastage stage used for data transformation and manipulation.
Transformer stage is used to perform complex data transformations and manipulations.
It allows users to define custom logic using graphical mapping.
It supports various functions and operators for data manipulation.
Transformer stage can be used to filter, aggregate, join, and sort data.
It can also be used to perform calculations, convers...
Skills evaluated in this interview
Thomas George
I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell us about yourself. What are some of your achievments
- Ans.
I'm a passionate Software Engineer with a strong background in developing scalable applications and a knack for problem-solving.
Developed a web application that improved user engagement by 30% through enhanced UI/UX design.
Led a team of 5 engineers in migrating a legacy system to a microservices architecture, reducing downtime by 40%.
Contributed to open-source projects, including a popular library that has over 1,000 s...
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is a bit
- Ans.
A bit is the smallest unit of data in computing, representing a binary value of 0 or 1.
A bit can represent two states: off (0) or on (1).
Bits are the building blocks of all digital data, including text, images, and sound.
In binary code, a sequence of bits can represent numbers, letters, and commands.
For example, the letter 'A' is represented as 01000001 in binary, which is 65 in decimal.
- Q2. What us the size of a bit
- Ans.
A bit is the smallest unit of digital information. It can have a value of either 0 or 1.
A bit is a binary digit, represented as either 0 or 1.
It is the basic unit of information used in computing and digital communications.
A group of 8 bits is called a byte.
The size of a bit is dependent on the architecture of the computer system.
- Q3. How many bits are there in C
- Ans.
C is a programming language and does not have a fixed number of bits.
C is a high-level programming language that can be compiled to run on different architectures with varying bit sizes.
The number of bits in C depends on the hardware architecture it is compiled for.
For example, C code compiled for a 32-bit architecture will have 32-bit integers, while code compiled for a 64-bit architecture will have 64-bit integers.
Interview Preparation Tips
Skills evaluated in this interview
HCLTech Interview FAQs
Tell us how to improve this page.
HCLTech Interviews By Designations
- HCLTech Software Engineer Interview Questions
- HCLTech Technical Lead Interview Questions
- HCLTech Lead Engineer Interview Questions
- HCLTech Analyst Interview Questions
- HCLTech Senior Analyst Interview Questions
- HCLTech Senior Software Engineer Interview Questions
- HCLTech Technical Specialist Interview Questions
- HCLTech Software Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 3 interview experiences
Interview Questions from Similar Companies
HCLTech Datastage Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Software Engineer
25.2k
salaries
|  ₹2.7 L/yr - ₹8.1 L/yr |
|
Technical Lead
23.3k
salaries
| ₹10.7 L/yr - ₹23 L/yr |
|
Senior Software Engineer
17k
salaries
| ₹5.5 L/yr - ₹16.1 L/yr |
|
Lead Engineer
16.6k
salaries
| ₹5.8 L/yr - ₹12.5 L/yr |
|
Analyst
16.1k
salaries
| ₹2.3 L/yr - ₹6.6 L/yr |
TCS
Wipro
Accenture
Cognizant
- Home >
- Interviews >
- HCLTech Interview Questions
