Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

What are the types of containers in datastage?

0 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---

what is mapping lookup

1 Answers  

---

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

---

detail about sdlc

4 Answers  

---

What is a folder? Difference types of stages?

0 Answers  

---

What are the types of hashed files in data stage

0 Answers  

---

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,

---

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

---

How did you reconcile source with target?

2 Answers   HP,

---