How to delete duplicate records in a flat file source?
- 2 Answers
- 8140 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 are the transformations that are not supported in mapplet?
What are the circumstances that infromatica server results an unreciverable session?
Explain what are the different versions of informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the difference between bitmap and btree index?
How do you load unique records into one target table and duplicate records into a different target table?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Why we need XMLs?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
Diff b/w ShortCut and reusabel Object ?
Under what condition selecting sorted input in aggregator may fail the session?
what is galaxy repository?
Teradata 
