Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8291 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
Seq stg------>Sort stg--------> Trnsfrm stg-------->Tgt
1. read data in seq file stage.
2. In sort stage enable key column change as true.
3. In transformer stage define stage variable SV1 (if DSLink5.keyChange = 1 then 1 else SV1 +1) and SV2 (if DSLink5.keyChange = 1 then DSLink5.ENAME else SV2 : ',' : DSLink5.ENAME
) . In output tab link ENO, SV2 -> Ename and SV1 -> Count. Add a constraint LastRowInGroup(DSLink5.ENO) and mark the ENO as key in input column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps needed to create a simple basic datastage job?
Why do we use exception activity in Datastage?
What is the difference between an operational datastage and a data warehouse?
Explain the importance of surrogate key in data warehousing?
Describe routines in datastage? Enlist various types of routines.
what is 'reconsideration error' and how can i respond to this error and how to debug this
Is it possible to query a hash file?
What are the types of containers in datastage?
What is the difference between Datastage 7.5 and 7.0?
What is apt_config in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the difference between orabulk and bcp stages?
How do y read Sequential file from job control?
how to add a new records into source?
How do you start developing a datastage project?
