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 is active and passive stage?

876

---

What is orabulk stage?

631

---

What are the various kinds of containers available in datastage?

563

---

Differentiate between data file and descriptor file?

617

---

What are the partitioning techniques available in link partitioner?

1753

---

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2179

---

What is merge stage?

762

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

545

---

How a routine is called in datastage job?

605

---

What are the different common services in datastage?

705

---

Can you explain kafka connector?

775

---

On which Dimension Table you implemented SCD Type in your Project

1578

---

How do you generate sequence number in datastage?

625

---

How will you move hashed file from one location to another location?

1655

---

How complex jobs are implemented in datstage to improve performance?

596

---