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

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

What is the functionality of update strategy?

2 Answers  

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

How would you join a node to the already existing domain?

0 Answers  

Where are the source flat files kept before running the session?

0 Answers   Informatica,

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

Explain the different dimensions.

0 Answers  

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

what are objects in data warehouse?

2 Answers   Mind Tree,

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

For more Informatica Interview Questions Click Here
Categories