Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10329 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
How a source file is populated?
Explain usage analysis in datastage?
CHANGE CAPTURE
How do y read Sequential file from job control?
Nls stands for what in datastage?
What is a merge in datastage?
Define data aggregation?
what are the errors,warnings in datastage
Have you used Unstructured data?
what is flow of project?
What is orabulk stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
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
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
What are the components of datastage?
