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
Can anyone tell me the new features in Informatica 9 Version?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Briefly describe lookup transformation?
What are Dimensional table?
can anyone explain me about retail domain project in informatica?
How to partition the Session?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to Create a folder using pmrep command?
What are session parameters ? How do you set them?
how to load dimension table and fact table. plz tell me the steps.
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the designer tools for creating transformations?
Did u used latest transformations of 8.6.0? for what?
How to generate sequence numbers without using the sequence generator transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
