Answer Posted / subhash

From above all, these 3 are the correct ways using SQL:
A.
select * from emp as p where rowid<(select max(rowid) from
emp s where p.deptno=s.deptno);
B.
select * from sno
where sno in (select sno from emp
group by sno
having count(sno)>1
)
C.
1. SELECT A.COL1 FROM TABLE1 A

2. ( SELECT COL1, COUNT(COL1)FROM TABLE1
GROUP BY (COL1)
HAVING COUNT(COL1)=1)B

WHERE

3. A.COL1<>B.COL1

RESULT : 1. 10 20 30 40 10 20 50
2. 30 40 50
3. 10 10 20 20
And Using DataStage:
A.
Take source and copy,aggregate,JOIN,FILTER
1) give one copy output link to aggr, other to JOIN

2)In arggr perform count rows,
col1 COUNT
10 2
20 2
30 1
40 1
50 1

3) JOIN the two links(link1 from copy, link2 from AGG) and
use LEFT OUTER JOIN
col1 COUNT
10 2
20 2
30 1
40 1
10 2
20 2
50 1

4)And in FILTER, give constrains as count=1 to TARGET1 and
count>1 to TARGET2. in the TARGET2, u will get the desired
output.

Demonstrate experience in maintaining quality process standards?

2454

---

Have you have ever worked in unix environment and why it is useful in datastage?

1081

---

explain about citrix scheduling tool in datastage

2376

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2554

---

What are the primary usages of datastage tool?

1016

---

How rejected rows are managed in datastage?

1443

---

Could anyone give brief explanation bout datastage admin

2310

---

How can you write parallel routines in datastage PX?

973

---

What is the command line function to import and export the ds jobs?

1093

---

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

3732

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2836

---

Explain entity, attribute and relationship in datastage?

1042

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1439

---

Difference between sequential file and data set?

1133

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3129

---