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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by blocking transformation?

579


in reporting we add some new objects,how we get the count of the newly added objects to the report

1748


What does reusable transformation mean?

670


How many ways are there to do 'remove duplicate records in informatica'?

583


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

596






What is fact table? Explain the different kinds of facts.

610


What are the settings that you use to configure the joiner transformation?

611


What are mapplets? How is it different from a Reusable Transformation?

622


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1004


where to store informatica rejected data? How to extract the informatica rejected data?

597


How to join three sources using joiner? Explain though mapping flow.

693


How we can use union transformation?

606


How identifying bottlenecks in various components of informatica and resolving them?

578


What are the different ways to implement parallel processing in informatica?

858


Is it possible to use a client with different version than that of its Informatica server?

641