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


what is initial load and incremental load

Answers were Sorted based on User's Feedback



what is initial load and incremental load..

Answer / manikandan

The only difference that the inital load jobs were set to
first truncate the tables and then do a complete load and
the incremental load was set to insert new rows and update
existing rows for DIMENSION Tables. Facts jobs were same
(truncate and complete load)

Is This Answer Correct ?    17 Yes 4 No

what is initial load and incremental load..

Answer / pavani

initial load means :when ever the target table is empty on
that time we load from starting year data to up to this day
data we are loading into the taget like facts or dwh or
datamarts.this is initial loading.that data loadini time is
max20 to 30 hours time it takes ex 90 gb data something.


incremental loading means just coming data that means today
data that data load into target table this is called as
incremental loading(already previos data is loading into
tagets then just now comming data is loading into target
table that means updated data)it takes loading time is 3 to
4 hours.

Is This Answer Correct ?    12 Yes 0 No

what is initial load and incremental load..

Answer / saidarao

1.waht ever the data in the source is called intial load
(the data is already loaded in target is called before data)
2.the data which is generated after the data already loaded
is called after data
(the changes done in source are going 2 refresh the target
that is called incermental load)
per day-360 times

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Data Stage Interview Questions

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  


Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,


I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,


1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,


How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,


Where do the datastage jobs get stored?

0 Answers  


Could anyone give brief explanation bout datastage admin

0 Answers  


What is active and passive stage?

0 Answers  


1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  


Categories