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
Sequence generator, when you move from develoment to production how will you reset
can anyone suggest best free Talend data integration training online
What is the format of informatica objects in a repository?
Design time, run time. If you don't create parameter what will happen
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Slowly changing dimensions, types and where will you use them
What is the maplet?
explain about unit testing? in real time?
what are the Methods For Creating Reusable Transformations?
What are the types of schemas we have in data warehouse and what are the difference between them?
What all join we can perform in LOOKUP transformation?
Differentiate between source qualifier and filter transformation?
What is meant by lookup transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
On which transformations you created partitions in your project?
