Answer / rajesh

In server Job:
open Aggregator properties, select output tab, select column
whatever u required to SUM, double click on Derivation
column, select the source column, and finally select the SUM
option in drop down list of Aggregate Function and click OK.

Answer / varaprasad rayi

hi , is there any posiblity in parallel jobs.?

Answer / potter

readable format in the sense?

Answer / nish

what he means is the default to decimal formatting option.

so that it doesnt display the default double data with many digits after decimal

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

what is flow of project?

0 Answers   HSBC, IBM,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---