SQL> SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*)

i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?

Question Posted / kalpana_241871

8 Answers
11329 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / kalpana_241871

SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) > 1 ;

O/P 1 :
1
1
1
2
2
2
3
3
SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) = 1 ;

O/P 2 :
4
5
6

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the datastage parallel extender (px) or enterprise edition (ee)?

742

What are the different type of jobs in datastage?

608

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

2084

Which algorithm you used for your hashfile?

692

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

683

Explain how a source file is populated?

767

How do you start developing a datastage project?

660

sed,awk,head

971

How a server job can be converted to a parallel job?

622

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1703

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

654

How to reverse the string using unix?

2815

Explain Quality stage?

671

What is ibm datastage?

607

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3271