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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What do you mean by channel change?
What is the different lookup cache(s)?
How is union transformation utilized?
Explain about Informatica server process that how it works relates to mapping variables?
have u done any performance tuning? how u ll do?
What are the new features of Power Center 5.0?
How would you copy the content of one repository to another repository?
How can we delete duplicate rows from flat files?
scenario where i can use only concurrent execution of workflow.
What are the databases that informatica can connect to windows?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to load last n records of file into target table - informatica
How many input parameters can exist in an unconnected lookup?
What are the types of lookup transformation?