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
- 13442 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
Explain usage analysis in datastage?
How do you register plug-ins?
What is staging variable?
describe the Steps to confiure a Qlogic switch
What are the benefits of datastage?
What are the different plug-ins stages used in your projects?
How will you move hashed file from one location to another location?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is data partitioning?
How many Key we can define in remove duplicate stage?
On which interface you will be working as a developer?
What are stage variables, derivations and constants?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How can we improve performance of data stage jobs?
What is the difference between odbc and drs stage?
