Answer Posted / subhash

we can use
NullToValue(Col_Name, Default_Value)
or
NullToempty(Col_Name)functions in tranformaer stage.

Or
If the source is sequential file then, we have an option in
seq file ==> Formats ===> Filed Defaults ==>"Null Field
Value" --> we can set default value for it.

What is the difference between informatica and datastage?

1300

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1922

---

What are the steps needed to create a simple basic datastage job?

1303

---

What are data elements?

1235

---

Define APT_CONFIG in Datastage?

1135

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1428

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1600

---

Can you explain players in datastage?

1246

---

What is the difference between datastage and informatica?

1182

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2408

---

Explain datastage architecture?

1449

---

What are the steps required to kill the job in Datastage?

1265

---

Define orabulk and bcp stages?

1172

---

What are some prerequisites for datastage?

1168

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

---