Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DELETE A RECORD FROM FLAT FILE
- 6 Answers
- 15903 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 |
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Which kind of index is preferred in DWH?
Explain the difference between mapping parameter and mapping variable?
How can u stop a batch?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
When to use normalization transformation other than cobol source?
How do we call shell scripts from informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Are there any types of Dynamic Caches in informatica
I have a flat file, want to reverse the contents of the flat file
Teradata 
