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
13774 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

What is orabulk stage?

1048

What are the types of jobs we have in datastage?

1075

What is the process of killing a job in datastage?

1021

Define APT_CONFIG in Datastage?

1084

What is the difference between datastage and informatica?

1121

How will you move hashed file from one location to another location?

2154

What is the difference between in process and inter process?

1155

How do you import and export the datastage jobs?

1161

Explain datastage architecture?

1404

How the ipc stage work?

1135

What is a merge in datastage?

1271

Difference between sequential file and data set?

1207

Where do the datastage jobs get stored?

1218

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

What is a folder? Difference types of stages?

1178