Series: Subject: Topic:
Question: 996 of 1135

can we modify the data in flat file?

Asked by: Interview Candidate | Asked on: Sep 20th, 2005
Showing Answers 1 - 11 of 11 Answers
ravikumar guturi

Answered On : Oct 4th, 2005


Login to rate this answer.

Answered On : Oct 28th, 2005

Manually Yes.

Login to rate this answer.

Answered On : Nov 4th, 2005


Login to rate this answer.

Answered On : Nov 23rd, 2005


Login to rate this answer.
Madhav Adireddi

Answered On : Jan 15th, 2006

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

Login to rate this answer.

Answered On : Jan 23rd, 2006

View all answers by sithusithu

Just open the text file with notepad, change what ever you want (but datatype should be the same)Cheerssithu

Login to rate this answer.
ravi kumar guturi

Answered On : Mar 10th, 2006

Yes by open a text file and edit

Login to rate this answer.

Answered On : Aug 17th, 2006

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

Login to rate this answer.

Answered On : Apr 2nd, 2008

View all answers by Vani_AT

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.

Login to rate this answer.
Noel Lastra

Answered On : Apr 9th, 2008

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

Login to rate this answer.

Answered On : 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.

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.