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

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

---

Define meta stage?

1206

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2110

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1158

---

how to add a new records into source?

2000

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2615

---

What steps should be taken to improve Datastage jobs?

1074

---

What is ds designer?

1106

---

Difference between data warehousing and olap?

1093

---

Why fact table is in normal form?

1252

---

Explain Quality stage?

1160

---

What all the types of jobs you developed?

1181

---

What are the components of ascential data stage?

1189

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---