Answer Posted / akila ramu

DB--->Transformer--->Output File

Sample data propagation through these stages:
In table->DB stage--->Tfm----->outputfile
101 0---->100 0 2 2-->100 0
100 0---->101 0 2 1-->100 0
101 1---->101 1 2 1
100 0

DB: Use the bvelow query in this stage
select emp_id, ind, count(emp_id) c1, count(emp_id ind) c2
from table_name
group by emp_id, ind
order by emp_id, ind
So similar empid-ind are grouped and the count of each
empid-ind pair is also sent in a seperate column c2. The
count of each emp_id is sent in c1.

Tfm: Output link Contraint:c1=c2
Looping contraint: @ITERATION<=c2
Looping variables: l_empid=emp_id
l_ind=ind

Pass these two looping variables as the emp_id and the ind
to the output file.

What all are the different way to run a job?

1088

---

how to export or import the jobs in .ISX file

1189

---

Explain ibm infosphere information server and highlight its main features?

1084

---

Can you explain players in datastage?

1185

---

What are the repository tables in datastage?

1301

---

What is datastage engine?

1168

---

Difference between server jobs & parallel jobs?

1071

---

Lookup constraints

1246

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1406

---

Differentiate between Join, Merge and Lookup stage?

1088

---

What is a merge?

1156

---

How to read multiple files using a single datastage job if files have the same metadata?

1240

---

Define Merge?

1310

---

Define data aggregation?

1089

---

Differentiate between odbc and drs stage?

1046

---