what is initial load and incremental load
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
State the difference between an operational datastage and a data warehouse?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
Name the command line functions to import and export the DS jobs?
Define orabulk and bcp stages?
Define Routines and their types?
what is a force compile
how can i abort the job if i get more than 100 errors in job log?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the difference types of stages?