Answer / datastage4you

Use Pivot stage

Thanks
www.datagenx.net

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

what r the sources u need to create the datastage?

1 Answers  

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  

---

How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

Can you explain tagbatch restructure operator?

0 Answers  

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---