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 a source file is populated?

1071

---

What is staging variable?

1100

---

Can you explain repository tables in datastage?

1411

---

What are the steps needed to create a simple basic datastage job?

1242

---

Why we use surrogate key?

1239

---

What is datastage?

1091

---

What are datastage sequences?

1126

---

What is the flow of loading data into fact & dimensional tables?

1067

---

How do you register plug-ins?

969

---

What is the difference between passive stage and active stage?

1542

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2239

---

State the difference between an operational datastage and a data warehouse?

1136

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3800

---

project Steps,hits, Project level HArd things,Solved methods?

2137

---

What is a ds designer?

1071

---