Answer Posted / srinivas

Use below stage variables

create 4 stage variables

STG1 =NAME:COMPANY

STG2=1

STG3= IF STG1:STG4 THEN STG3+1 ELSE STG2

STG4= STG1

create extra column for store this ranks.


After this stage use the sort stage to sort the data based on ranking column.

Then will get the exact output what we are looking.

krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2

What is difference between join, merge and lookup stage?

1103

---

Difference between data warehousing and olap?

1097

---

What is active and passive stage?

1415

---

Can you explain kafka connector?

1315

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2025

---

How can one find bugs in job sequence?

1425

---

what are the errors,warnings in datastage

2705

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2164

---

Difference between in process and inter process?

1242

---

Describe the main features of datastage?

1078

---

Have you used Unstructured data?

1326

---

What is the difference between an operational datastage and a data warehouse?

1157

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5127

---

What is the command line function to import and export the ds jobs?

1153

---