Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 13759 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhash
SQL> small correct in Query provided by Kalpana.
SELECT COL1 FROM TAB1 WHERE COL1 IN
(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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between orabulk and bcp stages?
Demonstrate experience in maintaining quality process standards?
Define orabulk and bcp stages?
Define Data Stage?
What is staging variable?
What is merge stage?
Why do we use link partitioner and link collector in datastage?
What are sequencers?
What are the different type of jobs in datastage?
Differentiate between datastage and datastage tx?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What is ibm datastage flow designer?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
