Answer Posted / indu

Input->Sort1->Sort2->Trnsformer->Output

Sort1-->Declare class_id and Marks as key column and sort
in descding order.
Sort2-->Declare class_id and Marks as key column(Sort Mode
to Dont sort previously sorted for both) and set clustered
key change column to true.

Otuput for Sort 2 will be

class_id Marks Rank
102 90 1
102 35 0
101 60 1
101 50 0
101 40 0

In the Transformer declare stage variable temp and
initialize to o

Derive temp--> If Rnak=1 then Rank else temp+1

Derive output columns as --->

class_id ---> class_id
Marks ----> Marks
Rank----> temp

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2295

---

What are iconv and oconv?

1302

---

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

2491

---

what is flow of project?

2059

---

Difference between data warehousing and olap?

1151

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795

---

Explain datastage architecture?

1451

---

What could be a data source system?

1098

---

Differentiate between operational datastage (ods) and data warehouse?

1234

---

What are stage variables, derivations and constants?

1283

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2666

---

What can we do with datastage director?

1293

---

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

1923

---

How you can fix the truncated data error in datastage?

1887

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1548

---