Answer / kumar

go to partition--->select the partiton name other than auto-
-->check perform sort.

Answer / srinivas

We can sort the data by using Aggregator and Transformer

If we use the Aggregator will get only specified coulmns will not get all source columns.

If we use the transformer will get all columns with sorted output.

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

What are stage variables and constants?

0 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

What are the third party tools you used in your project?

1 Answers   IBM,

---

What is a merge?

0 Answers  

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

how to cleansing data

6 Answers   Cap Gemini,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---