Answer / mallika

Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value

how can u handle null values in transformer stage.

7 Answers  

---

What are iconv and oconv?

0 Answers  

---

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

what is a nodemap constraint

2 Answers   IBM,

---

What are the various kinds of containers available in datastage?

0 Answers  

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

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

3 Answers   IBM,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

What is ibm datastage flow designer?

0 Answers  

---