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?

 616

What is the difference between informatica and datastage?

 650

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

 580

Describe the architecture of datastage?

 562

Describe link sort?

 636

What is ibm datastage flow designer?

 679

What are operators in datastage?

 1 1300

What is a ds designer?

 636

How do you run datastage job from the command line?

 592

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

 762

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

 655

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

 543

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 795

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

 532

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

 356

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Why do we use exception activity in Datastage?

705

What are the steps needed to create a simple basic datastage job?

649

How do y read Sequential file from job control?

14393

What is the purpose of pivot stage?

598

Name the different types of Lookups in Datastage?

720




What is the difference between validated and compiled in the datastage?

695

Explain connectivity between datastage with datasources?

585

What are the primary usages of datastage tool?

620

Triggers,VIEW,Procedures

790

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2534

How a routine is called in datastage job?

599

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837

What is the project in datastage?

658

sed,awk,head

961

What is data partitioning?

739

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