what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

what is hash file

2 Answers   CTS, IBM,

---

what is a nodemap constraint

2 Answers   IBM,

---

To see hidden files in LINIX?

0 Answers   CTS,

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

How many areas for files does datastage have?

0 Answers  

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---