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

If you want to use the same piece of code in different jobs, how will you achieve it?

1161

---

How one source columns or rows to be loaded in to two different tables?

1131

---

Can you highlight the main features of ibm infosphere information server?

1090

---

How to RD using transformer?

1431

---

What are the difference types of stages?

1218

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

What is the difference between datastage and informatica?

1123

---

what is the difference between == and eq in UNIX shell scripting?

1502

---

What is a ds designer?

1071

---

what is ds administrator used for?

1175

---

How to read the length of word in unix?

1382

---

What are the steps needed to create a simple basic datastage job?

1242

---

Can you explain engine tier in information server?

1138

---

What is the difference between informatica and datastage?

1235

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088

---