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
Is it possible to use a client with different version than that of its Informatica server?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Clarify the aggregator change?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the types of caches in lookup? Explain them.
tell me 5 session failure in real time how can you solve that in your project?
What is exclusive and normal mode for repository services?
What is sequence generator transformation in informatica?
Which is the t/r that builts only single cache memory?
what is Active lock explain
What is the use of source qualifier?
When do you use sql override in a lookup transformation?
Enlist the differences between database and data warehouse.
Explain the shared cache and re-cache?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
