ajaj


{ City } pune
< Country > india
* Profession *
User No # 109563
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 2
Questions / { ajaj }
Questions Answers Category Views Company eMail




Answers / { ajaj }

Question { CGI, 4830 }

I have 3 jobs A,B and C , which are dependent each other. I
want to run A & C jobs daily and B job run only on sunday.
how can we do it?


Answer

Use Nested Condition, on link job b conditional day = 'Sunday' on
link job c conditional day <> Sunday use sequencer stage after job to and provide output to job C.

Is This Answer Correct ?    1 Yes 0 No

Question { Wipro, 6820 }

eno ename
1 qaz
1 wsx
1 edc
2 zxc
2 asd
3 qwe
3 wer
3 tru
4 rgj

Output:

eno ename count
1 qaz,wsx,edc 3
2 zxc,asd 2
3 qwe,wer,tru 3
4 rgj 1

I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.


Answer

select eno, ename, count(*) from Table_Name group by eno, ename

Is This Answer Correct ?    1 Yes 2 No