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

how to use incremental load?

Question Posted / chandrasekar

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

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1123

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6488

tell me about your project functionality

2341

How can informatica be used for an organization?

1214

can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

How does the aggregator transformation handle null values?

1147

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901

Whats the difference between informatica powercenter server, repositoryserver and repository?

1173

Quickly characterize reusable change?

1118

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4727

Explain the tuning lookup transformation - informatica

988

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2034

What is exclusive and normal mode for repository services?

1142

Which means the first record should come as last record and last record should come as first record and load into the target file?

1073

What is the difference between informatica 7.0 and 8.0?

1013