Answer Posted / mrvprasad

1)First go to Seq File-->Columns-->Add RowNum column and
2)then go to Properties-->select Options-->select Row Number Column=RowNum (Drop down list select RowNum column)
we will get the sequence Numbers.

first do the link sort for Sal in transformer stage.

and in Transformer stage go to
Constraint: Mod(dslink1.RowNum,2)=0 ---o/p1

and then select otherwise check box or write Mod(dslink1.RowNum,2)=1 --->0/p2

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1369

---

What are the benefits of datastage?

1230

---

How will you move hashed file from one location to another location?

2143

---

whom do you report?

1916

---

What all the types of jobs you developed?

1171

---

Can you explain repository tables in datastage?

1389

---

What is the method of removing duplicates, without the remove duplicate stage?

1006

---

Lookup constraints

1238

---

What are iconv and oconv?

1226

---

How complex jobs are implemented in datstage to improve performance?

1025

---

What is the precedence of stage variables,derivations, and constraints?

1069

---

Can we use target hash file as a lookup ?

3314

---

Is possible to create skid in dim,fact tables?

2628

---

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

997

---

how to add a new records into source?

1984

---