Answer Posted / pushparaj

Just modified the last post with minor changes

First sort the both name and compamy and then,
using stage variable in transformer:
sv1= name:company
sv3=if sv1=sv2 then sv3+1 else sv3(initial value of sv3=1)
sv2=sv1(initial value of sv2 =XXXXXXX)

OP

name company count=sv3

What are iconv and oconv?

1245

---

To see hidden files in LINIX?

1530

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

---

Which algorithm you used for your hashfile?

1183

---

How one source columns or rows to be loaded in to two different tables?

1130

---

Why we use surrogate key?

1236

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1391

---

what is the use of skid in reporting?

2381

---

What are routines in datastage?

1329

---

How to read the length of word in unix?

1380

---

What all the types of jobs you developed?

1181

---

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

2295

---

How a server job can be converted to a parallel job?

1096

---

Is it possible to query a hash file?

2012

---

What is the difference between odbc and drs stage?

1092

---