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?
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 are the functionalities of link collector?
How the ipc stage work?
What are iconv and oconv?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is use Array size in datastage
Define ds designer?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How you Implemented SCD Type 1 & Type 2 in your project?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What are the various kinds of containers available in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Describe routines in datastage? Enlist various types of routines.
Define oconv () and iconv () functions in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how