Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records in a flat file source?
- 2 Answers
- 8783 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
| Is This Answer Correct ? | 17 Yes | 6 No |
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 |
What is IQD file?
What does cheating measurement mean?
What is resilience time?
Define pmcmd command?
What is data merging,data cleansing,sampling?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How are the sources and targets definitions imported in informatica designer?
what is data modelling? what are types of modelling?In which suituation will use each one?
list out all the transformations which use cache?
What is the difference between a connected look up and unconnected lookup?
Teradata 
