HOW TO DELETE A RECORD FROM FLAT FILE
Answers were Sorted based on User's Feedback
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 |
Answer / ankit kansal
Three ways to achieve the result..
1) Sorter Transformation (Distinct Oprtion)
2) Aggregator Transaformation (Group by ALL PORTS)
3) Rank Transformation (Group by ALL) and RNK=1
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / subarna roy
We can write a query thru Sql transformation and delete specific records from flat file.
Is This Answer Correct ? | 0 Yes | 5 No |
Answer / jvdwhinfo
Using Seq. generator we can delete the desired record from
flat file.
Please let me know if you have any suggestions.
Thanks,
James
Is This Answer Correct ? | 2 Yes | 9 No |
Answer / gm
1.Why should we need to delete record from flat file?
Procedure:
We can Ignore record thru expression.
For Exp; Invalid Date, empty values some rows, etc..
Regards
Is This Answer Correct ? | 0 Yes | 7 No |
Answer / davan
By using sorter t/r have the property like distinct
optation.and also aggregator t/r check group by all ports.
Is This Answer Correct ? | 2 Yes | 17 No |
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What is main use of mapplet?
How to extract sap data using informatica? What is abap? What are idocs?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What are the associated ports in look up T/R.
What are the types of presistent cache in look up tr.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is option by which we can run all the sessions in a batch simultaneously?
tell me the push down optimization
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
why dimenstion tables are denormalized in nature ?