i have a scenario in which i/p columns areID,salary with
1,1000 2,2000 and 3,3000 i need an extra column in the o/p
named avg(salary)how can i get it?
- 4 Answers
- 8320 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sai
source -> Transforemer(add column and give value 1) ->
copy -> aggregate (take sum)
->Join -> tx -> target
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the use of datastage director?
How do you run datastage job from the command line?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are stage variables?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How can we improve performance of data stage jobs?
What are the types of containers in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the main features of datastage?
Differentiate between Join, Merge and Lookup stage?
Can you explain link buffering?
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
Differentiate between datastage and informatica?
Which commands are used to import and export the datastage jobs?
What is the difference between passive stage and active stage?
