Answer Posted / santosh
1.If you have duplicate data then you can use sorter or aggregator transformation to remove duplicate.
2. If u want to delete record after 50 the row then u can use sequence genetor.
3. Write the result to a other flat file as target.
4. Use 'Post session success command' in component tab of session task to delete the old flat file and rename the target flat file to old flat file.
Please correct me if this is wrong
Thanks and regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the components of workflow manager?
What are the reusable transformations?
What are the static cache and dynamic cache in informatica?
What are the advantages of using informatica as an etl tool over teradata?
How would you join a node to the already existing domain?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
permutations of mapplet
Reusable transformation and shortcut differences
How to generate sequence numbers without using the sequence generator transformation?
How can you increase the performance in joiner transformation?
Explain lookup transformation in informatica
What is lookup transformation?
What is the session task and command task?
What is different between the data warehouse and data mart?
In informatica workflow manager, how many repositories can be created?