Answer Posted / subhash

1.
Source--->Sort stage--->copy stage======>(SRC1,SRC2)
From copy stage we have to take two source stages
(SRC1,SRC2)
SRC-->Removeduplicate stage(in this we can get first
record from each dept--> Duplicates To Retain=First)
SRC2--->Remove duplicate stage(in this we can get last
record from each dept--> Duplicates To Retain=Last)
using funnel we can add these results.

2.
source->sortstage->removeduplications->dataset

in sortstage->create key changecolumn=true
this will set '1' for 1st records and '0' next duplicate
records.
after
removeduplicates stage(key columns=Deptno, CreateKeyChange
Columns)->duplicates retain:-last

we can get last(CreateKeyChange is zero and from all the
duplicates in that group, we are retaing last record) and
first(CreateKeyChange is 1) record group(Dept) wise.

What is the importance of the exception activity in datastage?

1018

---

What is meta stage?

1132

---

How to find value from a column in a dataset?

2149

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1371

---

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

2407

---

How do u convert the columns to rows in datastage?

1142

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

What are some prerequisites for datastage?

1042

---

What are the processing stages?

1041

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1197

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5046

---

What are the stages in datastage?

1033

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

---

How to reverse the string using unix?

3432

---

Explain connectivity between datastage with datasources?

942

---