Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

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,

---

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?

1 Answers   IBM,

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

which r the connectors used in san?

0 Answers  

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

---

What is apt_config in datastage?

0 Answers  

---

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

---