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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between source qualifier transformations source filter to filter transformation?

996


update strategy transformation in informatica

1014


Which is the t/r that builts only single cache memory?

1126


What is meant by active and passive transformation?

1031


What is the status code in stored procedure transformation?

1119


What is workflow manager?

988


Define mapplet?

961


What do you understand by a term domain?

1062


Make a note of the quantity vaults made in informatica?

942


What is olap (on-line analytical processing?

1007


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8126


To import the flat file definition into the designer where should the flat file be placed?

1004


What are the guidelines to be followed while using union transformation?

1065


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

970


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1950