Answer Posted / sagnik mukherjee

Hi,
You can try one thing.In the file stage where you are reading the file, there in columns metadata tab, set Null as 'Yes' for that particular column and do the same for the other stages too in that job.
Sometimes if you are getting null value from source but your column is set as 'No' for Null then this error can come.

Differentiate between data file and descriptor file?

1047

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1495

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2718

---

how to delete one row in target dataset

3111

---

What is ds designer?

1093

---

What is the different type of jobs in datastage?

962

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

930

---

Where do you see different stages in the designer?

1084

---

what is use of SDR function?

5167

---

How do you schedule or monitoring the job?

1204

---

What is process model?

1966

---

Where the datastage stored his repository?

1080

---

Which commands are used to import and export the datastage jobs?

1410

---

What are the types of containers and how to create them?

971

---

What is merge stage?

1298

---