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.

Explain datastage architecture?

1392

---

What is "fatal error/rdbms code 3996" error?

1257

---

Why fact table is in normal form?

1238

---

State the difference between an operational datastage and a data warehouse?

1131

---

Why do you need stage variables?

1180

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1146

---

Can you implement SCD2 using join, transformer and funnel stage?

1545

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3245

---

Why do we use link partitioner and link collector in datastage?

1129

---

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

1080

---

How to read multiple files using a single datastage job if files have the same metadata?

1240

---

how many rows sorted in sort stage by default in server jobs

3993

---

How a source file is populated?

1059

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2438

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1499

---