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 / moorthy g

Answer Posted / moorthy g

Source --->SQ ----> Expression ---> Target

===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date

====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1577

What are the informatica performance improvement tips

1088

Explain the mapping variable usage example in informatica

1155

What are the different components of powercenter?

1047

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1044

What is domain and gateway node?

1160

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1918

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2175

How many numbers of sessions can one group in batches?

1060

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1956

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

8197

Where can we find the throughput option in informatica?

1057

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

2294

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1487

What is informatica powercenter repository?

1196