Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi,
I have one flatfile as target in a mapping . When i am
trying to load data second time into it.
The records already is in flatfile is getting override. I
don't want to override existing records.
Note : we can do this by implementing CDC / Incremental pool
logic if target is relational .
But this is flatfile. So, even i use this same technique it
will override only
So what is the solution ?
Is there any option at session level for flatfile target ?
Advance Thanks

Question Posted / c manojkumar

Answers were Sorted based on User's Feedback



Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into i..

Answer / krish

there is an option like APPEND IF EXISTS in session
properties

Is This Answer Correct ?    11 Yes 1 No

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into i..

Answer / gvmahesh

It's very Simple We have one option at session level.

Double click on session-->Mapping tab-->>Target properties--
>Append if exists(check this option).

Is This Answer Correct ?    5 Yes 0 No

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into i..

Answer / jz

At session level goto target check only insert, thus every
time session runs it inserts the existing target file.

Is This Answer Correct ?    0 Yes 0 No

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into i..

Answer / manojkumar

Thank you krish.
It is working

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What do you understand by term role-playing dimension?

0 Answers  

How will the document be delivered to me?

0 Answers  

what are the types of facts with Examples?

3 Answers  

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

What is the scenario which compels informatica server to reject files?

0 Answers  

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

What is a difference between complete, stop and abort?

0 Answers  

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

How do you implement scheduling in Informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories