Informatica - can we modify the data in flat file?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 140 of 626

can we modify the data in flat file?

Total Answers and Comments: 10

Last Update: April 09, 2008 Asked by: sarath

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 04, 2005 23:19:25

ravikumar guturi

RE: can we modify the data in flat file?

can't

Is this answer useful? Yes | No

October 28, 2005 16:11:01

Anonymous

RE: can we modify the data in flat file?

Manually Yes.

Is this answer useful? Yes | No

November 04, 2005 08:25:47

swati

RE: can we modify the data in flat file?

yes

Is this answer useful? Yes | No

November 23, 2005 11:01:02

vasundhra

RE: can we modify the data in flat file?

yes

Is this answer useful? Yes | No

January 15, 2006 22:16:39

Madhav Adireddi

RE: can we modify the data in flat file?

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

Is this answer useful? Yes | No

January 23, 2006 02:18:00

sithusithu

Member Since: December 2005 Contribution: 161

RE: can we modify the data in flat file?

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

Cheers

sithu

Is this answer useful? Yes | No

March 10, 2006 02:07:40

ravi kumar guturi

RE: can we modify the data in flat file?

yes by open a text file and edit

Is this answer useful? Yes | No

August 17, 2006 21:52:49

Me_Raj

RE: can we modify the data in flat file?

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

Is this answer useful? Yes | No

April 02, 2008 06:40:52

Vani_AT

Member Since: December 2007 Contribution: 16

RE: can we modify the data in flat file?

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.

Is this answer useful? Yes | No

April 09, 2008 13:12:14

#10

Noel Lastra

Member Since: February 2007 Contribution: 38

RE: can we modify the data in flat file?

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

Hope this helps.

Is this answer useful? Yes | No

Go To Top