Answer Posted / shar

Ok
1) sql:
select empno, rank() over(order by empno) Ind from e2;
then we get:
100 1
100 1
100 1
101 2
101 2
103 3

2) Datastage:
sequl file-->sort-->tx--> Target.
@sort:
create keychange column then we get
100 0
100 1
100 1
101 0
101 1
101 1
102 0
102 1
103 0
@ Tx use two stage variables:
sv1 integer = 0 value
sv2 integer = 0 value
and at derivations :
assign
1) keychange ---> sv1
2) if sv1=0 then sv2+1 else sv2 ----> sv2

map the columns empno and sv2
and we get the results.
Thats it.
shar

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

---

What are the types of containers and how to create them?

982

---

How will you move hashed file from one location to another location?

2155

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2974

---

What are the difference types of stages?

1218

---

What is the importance of the exception activity in datastage?

1073

---

What are routines in datastage? Enlist various types of routines.

1103

---

What are the features of datastage flow designer?

1043

---

Which warehouse using in your datawarehouse

2191

---

project Steps,hits, Project level HArd things,Solved methods?

2137

---

Describe the main features of datastage?

1078

---

How can one find bugs in job sequence?

1424

---

What are the different common services in datastage?

1290

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

Name the third party tools that can be used in datastage?

1079

---