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
- 8767 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 are active and passive transformations?
How are indexes created after completing the load process?
What does reusable transformation mean?
What is informatica powercenter repository?
How do you load only null records into target?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Difference between Data and Index Caches?
Which transformation is needed while using the Cobol sources as source definitions?
How union transformation is used?
Different sorts of metadata that stores in the storage facility?
How can you validate all mappings in the repository simultaneously?
Write the different tools in the workflow manager?
What is the use of transformation?
What are mapplets? How is it different from a Reusable Transformation?
What are the designer tools for creating transformations?
