Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

What is the importance of the exception activity in datastage?

892

What is the difference between informatica and datastage?

945

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

849

Describe the architecture of datastage?

820

Describe link sort?

852

What is ibm datastage flow designer?

931

What are operators in datastage?

1 1741

What is a ds designer?

884

How do you run datastage job from the command line?

878

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

1118

892

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

838

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 1192

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

769

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

630

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How many Key we can define in remove duplicate stage?

1118

how do u catch bad rows from OCI stage? And what CLI stands for?

2602

Difference between data warehousing and olap?

884

On which interface you will be working as a developer?

871

table actions available in oracle connector?

1406

What is the difference between an operational datastage and a data warehouse?

923

Could anyone give brief explanation bout datastage admin

2202

What are the types of containers?

953

What is the difference between datastage and informatica?

908

What is the difference between orabulk and bcp stages?

826

What is the command line function to import and export the ds jobs?

937

How a routine is called in datastage job?

886

What is a merge?

901

What are the important features of datastage?

879

What all the types of jobs you developed?

940

For More Un-Answered { Data Stage } Questions Click Here