ravikumar guturi
Answered On : Oct 4th, 2005
can't
Login to rate this answer.
Anonymous
Answered On : Oct 28th, 2005
Manually Yes.
Login to rate this answer.
swati
Answered On : Nov 4th, 2005
yes
Login to rate this answer.
vasundhra
Answered On : Nov 23rd, 2005
yes
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.
Just open the text file with notepad, change what ever you want (but datatype should be the same)
Cheers
sithu
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.
Me_Raj
Answered On : Aug 17th, 2006
You can generate a flat file with program....mean not manually.
Login to rate this answer.
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.
You can modify the flat file using shell scripting in unix ( awk, grep, sed ).
Hope this helps.
Login to rate this answer.
sppk
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.
