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
Answer / 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 |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
How the informatica server sorts the string values in Rank transformation?
Design a mapping to get year of join for each employee.
How can we create index after completion of load process?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is a node in Informatica?
what is the purpose of surrogate key and diff between primary key&surrogate key
in performance wise union is past,union all is past
what is threshold error in informatica?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How can we use mapping variables in informatica?