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

AGGREGATOR default datatype

1389

---

what are the errors,warnings in datastage

2621

---

What is the difference between the local container and shared container?

1043

---

How can we improve the performance in datastage?

1060

---

Differentiate between validated and Compiled in the Datastage?

1196

---

How do you generate sequence number in datastage?

1027

---

What is the difference between orabulk and bcp stages?

969

---

What is the differentiate between data file and descriptor file?

1307

---

options available in sequence job to run,validate?

1260

---

What are the functionalities of link partitioner and link collector?

952

---

Define data aggregation?

1048

---

how can we create rank using datastage?what is the meaning of rank?

8706

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2386

---

how to implement scd2 in datastage 7.5 with lookup stage

5552

---

What are the some differences between 7.x and 8.x version of datastage?

1207

---