HOW TO DELETE A RECORD FROM FLAT FILE
- 6 Answers
- 13580 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What is event and what are the tasks related to it?
Enlist few areas or real-time situations where informatica is required.
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
what is datamart
what is the size of your data warehousing?
what is lookup ?
Explain the shared cache and re-cache?
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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the circumstances that infromatica server results an unreciverable session?
What is an aggregator transformation?
What is junk dimention?
Teradata 
