souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

What is a range lookup?

2 Answers   IBM,

---

What is the use of Row generator stage?

2 Answers  

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

Define repository tables in datastage?

0 Answers  

---

What are system variables and sequencers in datastage

0 Answers  

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

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,

---

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,

---

Is it possible to query a hash file?

0 Answers   IBM,

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---