Interested to Buy Any Domain ? << Click Here >> for more details...
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 happens when a session fails and you click on recover?
What is the difference between source qualifier transformations source filter to filter transformation?
tell me 5 session failure in real time how can you solve that in your project?
How many dimensions are there in informatica?
What differs when we choose the sorted input for aggregator transformation?
What do you mean by channel change?
Design a mapping to load a target table with the following values from the above source?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the format of informatica objects in a repository?
what are 3 tech challenges/ common issues you face?
What is native users?
what is song in infrmatica...?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
