I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---

What is the difference between in process and inter process?

0 Answers  

---

---

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

---

what is ds administrator used for?

0 Answers  

---

how to find out number of records imported into source file?

1 Answers  

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

---

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,

---

How do you design PX Routines ?

1 Answers  

---

Describe the architecture of datastage?

0 Answers  

---