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
- 8290 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
How do you load first and last records into target table?
Explain what transformation and how many are there in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the Rank index port in Rank transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to load a Dimension ? and how to load a fact table?
What are the modules in Power Center
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Performance tuning( what you did in performance tuning)
EXL informatica Questions
What is domain in terms of informatica?
Tell me about MD5 functions in informatica
Clarify the utilization of aggregator cache record?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
