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 are the functionalities of link collector?

1135

---

What are the some differences between 7.x and 8.x version of datastage?

1305

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2520

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

---

What steps should be taken to improve Datastage jobs?

1120

---

What are the different layers in the information server architecture?

1173

---

What is ibm datastage?

1022

---

What are the various kinds of containers available in datastage?

1100

---

What are sequencers?

1172

---

How we can covert server job to a parallel job?

1257

---

How can one find bugs in job sequence?

1493

---

Enlist various types of routines in datastage.

1328

---

Have you used Unstructured data?

1368

---

What are the types of views in datastage director?

1824

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3401

---