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,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

What are stage variables, derivations and constants?

0 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---