Interview Questions Answers in Data Stage

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, 5448 }

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, 8138 }

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