Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DELETE A RECORD FROM FLAT FILE
- 6 Answers
- 15713 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 the difference between a table and the materialized view?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How can repository reports be accessed without sql or other transformations?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
how to design mapping half of source table records into one target and remaining half into another target
How to retrieve last two days updated records?
Useful UNIX commands regular/frequently used
how many types transformations supported by sortedinput?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
In informatica workflow manager, how many repositories can be created?
What are the types of error logs available in Informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
