How to delete duplicate records in a flat file source?
- 2 Answers
- 7743 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 aggregate cache in aggregator transforamtion?
What is sorter transformation?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Limitation of REPLACESTR. Is there any character limitation to it.
Plz can any one say me how to get the informatica certification materials and dumps
What are the different types of repositories created using informatica?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
What is the use of incremental aggregation?
How many cubes create from a single model?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
What all join we can perform in LOOKUP transformation?
Teradata 
