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 ds designer?

1252

---

Describe routines in datastage? Enlist various types of routines.

993

---

What is datastage engine?

1162

---

Give an idea of system variables.

1004

---

Describe the main features of datastage?

1065

---

Explain ibm infosphere information server and highlight its main features?

1078

---

Explain connectivity between datastage with datasources?

963

---

what is the use of materialized view?

1550

---

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

1026

---

What are the various kinds of the hash file?

1133

---

How rejected rows are managed in datastage?

1492

---

what is flow of project?

1979

---

How many types of hash files are there?

1161

---

How can we improve the performance in datastage?

1089

---

Name the third party tools that can be used in datastage?

1062

---