My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

How to Convert the columns into rows?

2 Answers  

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

Where do the datastage jobs get stored?

0 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

How we can covert server job to a parallel job?

0 Answers  

---