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
- 13683 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 difference between symmetric multiprocessing and massive parallel processing?
Can you explain link buffering?
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?
What are the types of jobs we have in datastage?
What are the different common services in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What are stage variables?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Give an idea of system variables.
How the ipc stage work?
What are the different kinds of views available in a datastage director?
To see hidden files in LINIX?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Describe link sort?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
