Answer Posted / swamy

Use field function in transformer stage. This function
performs based on delimeter... so, you can use that field
function. like field(delimeter, occurance) - field means
(input column) delimeter ("-") occurance(2) ...

What is the importance of the exception activity in datastage?

1018

---

How to RD using transformer?

1367

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2839

---

How you can fix the truncated data error in datastage?

1677

---

What is difference between join, merge and lookup stage?

1041

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2327

---

What are the processing stages?

1041

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2928

---

Give an idea of system variables.

962

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3132

---

Where do the datastage jobs get stored?

1149

---

Define meta stage?

1144

---

What are the different common services in datastage?

1216

---

What is job control?

1034

---

How can one find bugs in job sequence?

1319

---