Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

What is the importance of the exception activity in datastage?

 834

What is the difference between informatica and datastage?

 876

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

 780

Describe the architecture of datastage?

 768

Describe link sort?

 808

What is ibm datastage flow designer?

 876

What are operators in datastage?

 1 1651

What is a ds designer?

 840

How do you run datastage job from the command line?

 802

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

 1042

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

 835

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

 804

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 1102

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

 712

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

 577

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What all the types of jobs you developed?

868

How you Implemented SCD Type 1 & Type 2 in your project?

3874

How a routine is called in datastage job?

809

Difference between sequential file and data set?

856

What is use Array size in datastage

1525

Difference between in process and inter process?

902

What is "fatal error/rdbms code 3996" error?

906

Differentiate between validated and Compiled in the Datastage?

886

Describe the main features of datastage?

839

Highlight the main features of datastage?

813

Can we use target hash file as a lookup ?

3033

Explain how a source file is populated?

1065

What is the difference between datastage and datastage tx?

786

Explain datastage architecture?

1062

Can you explain link buffering?

914

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