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
- 7806 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 sequence generator transformation in informatica?
How would you copy the content of one repository to another repository?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the components of Informatica? And what is the purpose of each?
Explain sessions and how many types of sessions are there?
Performance tuning( what you did in performance tuning)
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain sql transformation in script mode examples in informatica
What are the different components of powercenter?
What are the informatica performance improvement tips
What is powercenter on grid?
Where can we find the throughput option in informatica?
What is mapping debugger?
What is the Rank index port in Rank transformation?
How many number of sessions can one group in batches?
