Can we modify the data in flat file?

Showing Answers 1 - 11 of 11 Answers

ravikumar guturi

  • Oct 4th, 2005
 

can't

  Was this answer useful?  Yes

Anonymous

  • Oct 28th, 2005
 

Manually Yes.

  Was this answer useful?  Yes

swati

  • Nov 4th, 2005
 

yes

  Was this answer useful?  Yes

vasundhra

  • Nov 23rd, 2005
 

yes

  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

Me_Raj

  • Aug 17th, 2006
 

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

  Was this answer useful?  Yes

Vani_AT

  • 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

sppk

  • 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