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
- 2657 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 |
explain abt union t/r?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is casual dimension?
What r the type of indexes u generally used in informatica?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain constraint based loading in informatica
What is the difference between normal and bulk loading? Which one is recommended?
On which transformations you created partitions in your project?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What are the guidelines to be followed while using union transformation?
Teradata 
