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.

Notification Activity

1399

---

What are the functionalities of link partitioner?

1022

---

Which warehouse using in your datawarehouse

2185

---

AGGREGATOR default datatype

1460

---

How a source file is populated?

1066

---

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

2293

---

Name the different types of Lookups in Datastage?

1259

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

---

Lookup constraints

1256

---

Define oconv () and iconv () functions in datastage?

1416

---

Is it possible to query a hash file?

2012

---

What is the difference between datastage and datastage tx?

1066

---

How do you generate sequence number in datastage?

1094

---

Explain the situation where you have applied SCD in your project?

2040

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

---