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 is difference between join, merge and lookup stage?

1151

---

How to read the length of word in unix?

1434

---

What could be a data source system?

1098

---

What are the functionalities of link collector?

1138

---

CHANGE CAPTURE

1354

---

What is a ds designer?

1114

---

Name the different types of Lookups in Datastage?

1313

---

Differentiate between validated and Compiled in the Datastage?

1357

---

Differentiate between datastage and informatica?

1251

---

What is the difference between datastage and informatica?

1185

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2491

---

Describe routines in datastage? Enlist various types of routines.

1054

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

860

---

What are the types of containers in datastage?

1226

---

How do you import and export the datastage jobs?

1211

---