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 a datastage macro?

638

---

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)

528

---

Differentiate between Join, Merge and Lookup stage?

647

---

How a routine is called in datastage job?

609

---

What are the benefits of datastage?

726

---

---

Difference between data warehousing and olap?

653

---

CHANGE CAPTURE

896

---

how to add a new records into source?

1529

---

Define project in datastage?

668

---

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?

1748

---

How do you generate sequence number in datastage?

625

---

why do u need the IOS upgradation in a FC switch

1875

---

How rejected rows are managed in datastage?

925

---

What is the difference between validated and compiled in the datastage?

703

---

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

1808

---