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 is the difference between Link collector and Funnel Stages?

1 Answers  

---

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

How to remove blank spaces from data?

3 Answers  

---

How you can fix the truncated data error in datastage?

0 Answers  

---

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,

---

What is RCP?

2 Answers   TCS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

---

What are the job parameters?

0 Answers  

---

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

---

What is the difference between lookup and sparse lookup?

1 Answers  

---