By using sorter t/r select distinct option it eliminate the duplicates.

source
file name xyz

a,0,a,a,a
b,b,b,0,b
c,c,c,0,c

target should be like this

xyz
a
b
c

how to implement this?

Question Posted / amedela chandra sekhar

Answer Posted / amedela chandra sekhar

By using sorter t/r select distinct option
it eliminate the duplicates.

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active?

1027

In development project what is the process to follow for an etl developer from day1

1698

How many input parameters can exist in an unconnected lookup?

1530

Explain how to import oracle sequence into informatica?

987

How can you validate all mappings in the repository simultaneously?

1349

What is the difference between informatica 7.0 and 8.0?

989

Tell me about MD5 functions in informatica

916

What is rank transform?

980

What are the types of caches in lookup?

1035

expain about the tune parameters?

2393

What do you understand by a term domain?

1109

what is $$$$?

2130

What are the different types of transformation available in informatica.

1082

What is the benefit of partitioning a session?

1159

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2707