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

how to use incremental load?

Answer Posted / chandrasekar

Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.

Using SCD type 2 we can acheive the incremental load.

If it wrong means chandranmca2007@gmail.com

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2277


Can we create a node as a gateway node and the same node can be assigned to a grid?

1026


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

1039


Explain lookup transformation source types in informatica

1040


What are the various types of transformation?

1094


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1089


How do you set a varible in incremental aggregation

1826


Where can we find the throughput option in informatica?

996


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

1004


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2209


State the limitations where we cannot use joiner in the mapping pipeline?

994


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994


What are the different types of olap? Give an example?

974


Explain dynamic target flat file name generation in informatica

1008


What are the tuning techniques you applied during your last project

1965