1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

Can you explain tagbatch restructure operator?

0 Answers  

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

How to RD using transformer?

0 Answers   CTS,

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

how to validate the jobs

2 Answers   IBM,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---