Answer Posted / narayana kota

Hi

you can do this job using Pivot Stage convert these rows in
Columns by specify the column name in pivot stage as
first_column ,second_column and third_column and using
tranformer stage concatante first_column and second_column
using stage variables and pass to target.


if any method is there plz let me known
Regards
Narayana Kota
pnarayana12@gmail.com

what is 'reconsideration error' and how can i respond to this error and how to debug this

2675

---

How rejected rows are managed in datastage?

1577

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2226

---

What are stage variables, derivations and constants?

1283

---

describe the Steps to confiure a Qlogic switch

2439

---

Where do you see different stages in the designer?

1146

---

Explain datastage architecture?

1451

---

how to export or import the jobs in .ISX file

1254

---

How to manage date conversion in Datastage?

1188

---

Define Job control?

1228

---

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

3217

---

What steps should be taken to improve Datastage jobs?

1121

---

Is the value of staging variable stored temporarily or permanently?

1056

---

What is difference between server jobs & parallel jobs?

1091

---

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

1082

---