Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following table some duplicate present
1
1
2
2
3
3
4
5
i want the output unique one column duplicate another
column following format like
unique duplicate
1 1
2 2
3 3
4
5
- 2 Answers
- 5972 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nagarau puppala
select distinct country_id "unique", (case when count(country_id) > 1 then country_id else null end) "duplicate" from s_region
group by country_id order by duplicate;
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Define sessions in informatica etl?
Can we override a native sql query within informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
design of staging area?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
is it possible to index the data in cache of lkp transformation ?
Which development components of informatica have the highest usage?
What is a node in Informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Under which circumstances, informatica server creates reject files?
What is informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How can we store previous session logs?
Explain the types of transformations?
