Interested to Buy Any Domain ? << Click Here >> for more details...
my soure table is emp having columns sal,deptno in the
deptno 10,20,30deptno row are there expected out
put is min(sal) of 10th deptno,max(sal) of 20th
deptno,mean(sal) of 30th deptno using aggregation stage
- 4 Answers
- 8188 Views
- I also Faced
- E-Mail Answers
Answer Posted / varaprasad
hi preti,
dot post wrong answers, so many were depending on allinterviews so , if you correct then post it
so
seq---->agg --->filter deptno=10---targer ,
.....20
.....30
good luck ,
vara
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
Terminate Activity
What are the different kinds of views available in a datastage director?
Where the datastage stored his repository?
What is the process of killing a job in datastage?
How do you run datastage job from the command line?
Differentiate between data file and descriptor file?
Explain the importance of surrogate key in data warehousing?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are constraints and derivations?
Enlist various types of routines in datastage.
What is the difference between datastage and informatica?
What is the use of datastage director?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
