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 processing stages?

1099

---

What are the types of containers?

1234

---

Can you explain link buffering?

1176

---

Difference between data warehousing and olap?

1089

---

options available in sequence job to run,validate?

1316

---

How rejected rows are managed in datastage?

1520

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2384

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2242

---

What is difference between server jobs & parallel jobs?

1038

---

What is the flow of loading data into fact & dimensional tables?

1062

---

How many types of stage?

1177

---

AGGREGATOR default datatype

1460

---

What is datastage?

1083

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1215

---

Which warehouse using in your datawarehouse

2185

---