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
- 3464 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
how u know when to use a static cache and dynamic cache in lookup transformation.
task is running successfully but data is not loded why?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Which is the t/r that builts only single cache memory?
What does cheating measurement mean?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
To achieve the session partition what r the necessary tasks u have to do?
What are different types of transformations available in informatica?
How to create a non-reusable instance of reusable transformations?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Teradata 
