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.

Have you have ever worked in unix environment and why it is useful in datastage?

1133

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

---

Lookup constraints

1263

---

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

1064

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2453

---

What are the functionalities of link collector?

1085

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2971

---

Define project in datastage?

1101

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

921

---

what are the errors,warnings in datastage

2703

---

What is the differentiate between data file and descriptor file?

1364

---

What are the benefits of datastage?

1238

---

What is size of a transaction and an array means in a datastage?

1315

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

---

How many types of views are there in a datastage director?

1296

---