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
- 8891 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 update strategy transform?
How do you load alternate records into different tables through mapping flow?
What is data caches/ index caches?
How to use procedural logic inside infromatica?
how many types of dimensions are available in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the use of source qualifier?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain target update override in informatica
How you prepared reports for OLAP?
Briefly define reusable transformation?
Please let me know how to make encryption and decryption with example?
How to elaborate tracing level?
Performance tuning in UNIX for informatica mappings?
In which transformation you cannot drag ports into it?
