Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DELETE A RECORD FROM FLAT FILE
- 6 Answers
- 15892 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 |
Router T/R is active but some people are saying it is also passive which is exactly right?
Can you use flat files in Mapplets.
how eliminate the duplicates in flat file with out using sorter ,aggregater
what is shared Cache. when we will use shared Cache?
Enlist the differences between database and data warehouse.
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
How will you update the first four rows and insert next four rows in a mapping?
how the server recognises , if the session fails after loading the 100 records in to the target
What are junk dimensions?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How can you generate reports in informatica?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Teradata 
