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
Which transformation should we use to normalise the COBOL and relational sources?
How to do unit testing in informatica? How to load data in informatica ?
Is stop and abort are same in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How you prepared reports for OLAP?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a sorter transformation?
What is the different lookup cache(s)?
Explain sessions. Explain how batches are used to combine executions?
Briefly define a session task?
Can we create two repositories on same database instance in oracle?
What are the tasks that source qualifier perform?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
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
How is union transformation utilized?
