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

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


Please Help Members By Posting Answers For Below Questions

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1703


How many types of sessions are there in informatica.please explain them?

949


What is aggregator transformation in informatica?

752


Define mapping and session?

797


Whats the difference between informatica powercenter server, repositoryserver and repository?

946


What is source qualifier transformation in informatica?

763


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1435


What are the restrictions of union transformation?

819


How many number of sessions can one group in batches?

915


How are indexes created after completing the load process?

1251


How many input parameters can exist in an unconnected lookup?

1308


explan ur project architecture?

1846


What is decode in informatica?

838


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1797


what is degenerated dimension?

3528