I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

what is the use of invokation id

2 Answers   IBM,

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

what is parameterset?

4 Answers   Wipro,

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

In merge stage can we update the values?

3 Answers   TCS,

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---