how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---

How do you design PX Routines ?

1 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

---

Enlist various types of routines in datastage.

0 Answers  

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

How do you start developing a datastage project?

0 Answers  

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

Can you explain repository tables in datastage?

0 Answers  

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---