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.

client know skid info?

0 Answers   NTT Data,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

---

How did you reconcile source with target?

2 Answers   HP,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---