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 is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2041

---

EXPLAIN SCD

1338

---

How to reverse the string using SQL?

1425

---

Describe routines in datastage? Enlist various types of routines.

954

---

How can you write parallel routines in datastage PX?

974

---

What is the difference between orabulk and bcp stages?

967

---

How many types of hash files are there?

1117

---

What is process model?

1919

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1440

---

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)

867

---

how to write server Routine coding?

2061

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2226

---

how to delete one row in target dataset

3061

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2405

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2324

---