Interested to Buy Any Domain ? << Click Here >> for more details...
write s sql query following table some duplicate present i
want unique one column duplicate another column display?
name id
a 1
a 1
b 2
b 2
c 3
i want the required output like
unique duplicate
name id name id
a 1 a 1
b 2 b 2
c 3
- 4 Answers
- 8934 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / ram pothineni
1) In SQ.. override the default query as below..
SELECT NAME,ID,ROW_NUM()OVER(PARTITION BY NAME ORDER BY
NAME)RN FROM TABLE_NAME
2) In router create two groups
UniqueGroup - RN = 1
DuplicateGroup - RN > 1
3) Connect Respective group to respective targets...
-- Ram Pothineni
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a stored procedure transformation?
What is blocking transformation?
What are the different components of powercenter?
how to load rows into fact table in data warehouse
Separate from a database, an information bazaar, and an information stockroom?
Is stop and abort are same in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Why update strategy and union transformations are active?
How many ways are there to do 'remove duplicate records in informatica'?
what is Active lock explain
What are the differences between source qualifier and joiner transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
How to use procedural logic inside infromatica?
What are the guidelines to be followed while using union transformation?
explain abt ur project architecture?
