Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following table?
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
i want the output like
unique duplicate
col1 col2 col1 col2
1 2 1 2
3 4 1 2
5 6
- 1 Answers
- 3554 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vaibhav jogale
We can achieve this using With clause
insert into TEST_UNIQ (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no=1
/
insert into TEST_DUp (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no>1
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain sessions?
Describe data concatenation?
What is a router transformation?
What is a passive transformation?
Explain joiner transformation in informatica
How many input parameters can exist in an unconnected lookup?
On which transformations you created partitions in your project?
Can you use flat files in Mapplets.
expain about the tune parameters?
What is the difference between a connected look up and unconnected lookup?
What is workflow? What are the components of workflow manager?
Is it possible to create multiple domains on a single Informatica server?
Separate from an archive server and a powerhouse?
What is informatica? Why do we need it?
Explain the different lookup methods used in informatica?
