How to delete duplicate records in a flat file source?
Answer Posted / sushanth1234
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are batches?
How do you manage the Parameter files while migrating your data from one environment to another environment?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain lookup transformation in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What you know about transaction control transformation?
What is InformaticaPowerCenter?
where to store informatica rejected data?
what is the -ve test case in your project.
How to elaborate tracing level?
What is Index Caches size?
What are the new features of informatica 9.x in developer level?
how to create user defined function (udf) in informatica
update strategy transformation in informatica
How many dimensions are there in informatica?