Answer Posted / radhakant kumar

hey it is just a example it could be like this..
1 Srini
1 vasa
1 aaaaa
the complete solution will be
say col1 and col2 so define stage variable in transformer
col1--------------->a(interger)
col2--------------->b(varchar)
if a=c then d:b else ''-->e(varchar)
e----->d(varchar)
a----->c(integer)

then in target pass e value to col2 and map col1 to col1

How many types of stage?

1135

---

What are stage variables, derivations and constants?

1169

---

What is the difference between in process and inter process?

1094

---

Difference between sequential file and data set?

1136

---

Give an idea of system variables.

966

---

What is a merge?

1078

---

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

---

Notification Activity

1351

---

what is flow of project?

1939

---

Explain Quality stage?

1094

---

What is the purpose of pivot stage and types of containers in datastage

996

---

how to abort the job its matain duplicates?

2535

---

How do y read Sequential file from job control?

15806

---

How complex jobs are implemented in datstage to improve performance?

967

---

What are stage variables and constants?

1098

---