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

Differentiate between joiner and lookup transformation?

0 Answers  

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

What are the basic needs to join two sources in a source qualifier?

3 Answers  

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

What is the need of building a data warehouse?

2 Answers  

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

What is source qualifier transformation?

1 Answers  

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories