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
Does an informatica transformation support only aggregate expressions?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you handle two sessions in Informatica
What is native users?
Can anyone tell me the new features in Informatica 9 Version?
How to load a Dimension ? and how to load a fact table?
Can we create two repositories on same database instance in oracle?
What is informatica? Why do we need it?
Differentiate between sessions and batches?
How to create or import flat file definition in to the warehouse designer?
Explain what are the different versions of informatica?
Explain the aggregator transformation?
What do think which one is the better joiner or look up?
What are the different types of repositories created using informatica?
What are the transformations that are not supported in mapplet?