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
What do you mean by blocking transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What does reusable transformation mean?
How many ways are there to do 'remove duplicate records in informatica'?
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?
What is fact table? Explain the different kinds of facts.
What are the settings that you use to configure the joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
where to store informatica rejected data? How to extract the informatica rejected data?
How to join three sources using joiner? Explain though mapping flow.
How we can use union transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What are the different ways to implement parallel processing in informatica?
Is it possible to use a client with different version than that of its Informatica server?