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

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

What is usage analysis in datastage?

0 Answers  

What is active and passive stage?

0 Answers  

How a server job can be converted to a parallel job?

0 Answers  

DataStage Scenario based Interview Questions

1 Answers  

How to read the length of word in unix?

0 Answers   CTS,

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

what are the errors,warnings in datastage

0 Answers   Wipro, Syntel,

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

How do you find the number of rows in a sequential file?

0 Answers  

What is use Array size in datastage

0 Answers