Can we modify the data in flat file?

Showing Answers 1 - 11 of 11 Answers

ravikumar guturi

  • Oct 4th, 2005


  Was this answer useful?  Yes


  • Oct 28th, 2005

Manually Yes.

  Was this answer useful?  Yes


  • Nov 4th, 2005


  Was this answer useful?  Yes


  • Nov 23rd, 2005


  Was this answer useful?  Yes

Madhav Adireddi

  • Jan 15th, 2006

Can you please explian how to do this without modifying the flat file manually?

  Was this answer useful?  Yes

ravi kumar guturi

  • Mar 10th, 2006

yes by open a text file and edit

  Was this answer useful?  Yes


  • Aug 17th, 2006

You can generate a flat file with program....mean not manually.

  Was this answer useful?  Yes


  • Apr 2nd, 2008

Let's not discuss about manually modifying the data of flat file.

Let's assume that the target is a flat file. I want to update the data in the flat file target based on the input source rows. Like we use update strategy/ target properties in case of relational targets for update; do we have any options in the session or maaping to perform a similar task for a flat file target?

I have heard about the append option in INFA 8.x. This may be helpful for incremental load in the flat file.
But this is not a workaround for updating the rows.
Please post your views.

  Was this answer useful?  Yes

Noel Lastra

  • Apr 9th, 2008

You can modify the flat file using shell scripting in unix ( awk, grep, sed ).

Hope this helps.

  Was this answer useful?  Yes


  • Jul 18th, 2011

The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions