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.

How To find the location of APT_confid file

2 Answers   CTS,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

Difference between in process and inter process?

0 Answers  

---

What is a ds designer?

0 Answers  

---

what is executable in DataStage?

2 Answers  

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

What are the stages in datastage?

0 Answers  

---