Through Dynamic lookup you can handle it very easily.

if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh

the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)

Question Posted / rajendra

5 Answers
12818 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / rajendra

Through Dynamic lookup you can handle it very easily.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica? How to load data in informatica ?

1123

What is an Integration service in Informatica?

1136

How do you load only null records into target?

1217

Please let me know how to make Data masking in informatica..

1729

What is joiner transformation in informatica?

1046

How we can create indexes after completing the load process?

1161

can we override a native sql query within informatica? How do we do it?

1130

How to Create a folder using pmrep command?

1178

Difference between Data and Index Caches?

1142

Explain pushdown optimization $pushdownconfig parameter - informatica

1150

What is resilience time?

1149

Differentiate between router and filter transformation?

1016

Explain the features of connected and unconnected lookup.

936

What is the different lookup cache(s)?

1089

What is the need of an ETL tool?

1104