Answer Posted / radhakant kumar

1)by sql say the column name is Id then
a)(for duplicate)
select a.id
from table_name a
left outer join(select id,count(*)as no1
from table_name
group by id
)b
on b.id=a.id
where b.no1>1
order by a.id
it will display 1 1 1 2 2 3 3
b)change the condition where b.no1=1 then it will display
the remainings without duplicates..
2) By DataStage
Step By Step....
a)after source file take Copy stage and draw two
output links
b)one will go to Aggregate stage and take count of
rows by group by Field(id)
it will display like.
ID Count(no)
1 3
2 3
3 2
4 1
5 1
6 1
c)and then use lookup stage main stream will be second link
of copy and reference will be output of Aggregate stage
d)look up key will be ID and fetch count(no) to target
it will display
ID Count(no)
1 3
1 3
1 3
2 3
2 3
2 3
3 2
3 2
4 1
5 1
e)and after lookup stage take transformer or filter stage
by taking two output links and put condition
a)for duplicates count(no)>1
b)for non duplicates count(no)=1

Finally u will get your desired output..
6

Define project in datastage?

1149

---

describe the Steps to confiure a Qlogic switch

2438

---

What is the roundrobin collector?

1150

---

explain about citrix scheduling tool in datastage

2510

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1922

---

What are stage variables?

1255

---

How do you start developing a datastage project?

1160

---

Explain usage analysis in datastage?

1224

---

What are the functionalities of link partitioner?

1067

---

What are the steps needed to create a simple basic datastage job?

1306

---

What is the flow of loading data into fact & dimensional tables?

1112

---

Why do we use exception activity in Datastage?

1371

---

What is the difference between informatica and datastage?

1303

---

What is the purpose of pivot stage and types of containers in datastage

1082

---

in oracle target stage when we use load option and when we use upsert option?

2323

---