Data Stage Interview Questions
Questions Answers Views Company eMail

What is the importance of the exception activity in datastage?

829

What is the difference between informatica and datastage?

876

What is the use of hoursfromtime() function in transformer stage in datastage?

779

Describe the architecture of datastage?

765

Describe link sort?

808

What is ibm datastage flow designer?

875

What are operators in datastage?

1 1651

What is a ds designer?

840

How do you run datastage job from the command line?

800

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1041

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

834

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

801

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 1099

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

710

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

575


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explain the situation where you have applied SCD in your project?

1765


How to reverse the string using unix?

3115


What is the process of killing a job in datastage?

743


What is the use of datastage designer?

845


How do y read Sequential file from job control?

15029


Which algorithm you used for your hashfile?

875


Differentiate between datastage and datastage tx?

813


What are the partitioning techniques available in link partitioner?

2010


Have you have ever worked in unix environment and why it is useful in datastage?

893


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1041


On which interface you will be working as a developer?

820


Nls stands for what in datastage?

935


Name the third party tools that can be used in datastage?

824


Distinguish between informatica & datastage. Which one would you choose and why?

748


What is the importance of the exception activity in datastage?

829