Answer Posted / subhash

1) If SRC is either Oracle or Seq File

SRC--->AGG---->fILTER---->TGT1
...................|
...................|
..................TGT2

the main data is:
sam
ram
sam
raj
ram
from aggregator stage, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

2) If SRC is DataBase,

Orcl Conector----->Filter---->TGT1
.......................|
.......................|
......................TGT2

SELECT NAME, COUNT(NAME)
FROM EABLE_NAME
GROUP BY (NAME)
from the Above Query, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

What is the sortmerge collector?

670

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

781

---

How to perform incremental load in datastage?

675

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2054

---

How we can covert server job to a parallel job?

601

---

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

368

---

What are the repository tables in datastage?

831

---

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

604

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2125

---

Difference between in process and inter process?

704

---

Highlight the main features of datastage?

617

---

Differentiate between Join, Merge and Lookup stage?

649

---

What are transforms and what is the differenece between routines and transforms?

618

---

What are the different type of jobs in datastage?

610

---

How the ipc stage work?

680

---