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
Briefly describe lookup transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Is there any target staging area in informatica not staging area
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can you define user defied event?
What are the types of lookup transformation?
What are the performance considerations when working with aggregator transformation?
wf dont have integration severances how you can run?
Define Pmrep command?
How can a transformation be made reusable?
Quickly characterize reusable change?
Sequence generator, when you move from develoment to production how will you reset
where to store informatica rejected data? How to extract the informatica rejected data?
What are data-driven sessions?
my source is junk data how will u remove that junk data by using unix please any one replay me
