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

What are the functionalities of link partitioner?

1068

---

How to clean the datastage repository?

1182

---

which r the connectors used in san?

2231

---

Can you explain repository tables in datastage?

1459

---

What are the main features of datastage?

1355

---

What is the difference between account and directory options ?

1234

---

what is the use of skid in reporting?

2427

---

Explain the importance of surrogate key in data warehousing?

1234

---

What are orabulk and bcp stages?

1165

---

How can we improve the performance in datastage?

1147

---

Is the value of staging variable stored temporarily or permanently?

1056

---

How to RD using transformer?

1480

---

Give an idea of system variables.

1092

---

Can you define merge?

1190

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1118

---