Answer Posted / 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 |
Post New Answer View All Answers
what are the devoleper roles in real time? plz tell i am new to datastage....
Name the different types of Lookups in Datastage?
Name the third party tools that can be used in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are stage variables and constants?
how to export or import the jobs in .ISX file
How to read the length of word in unix?
what is the use of skid in reporting?
What are system variables and sequencers in datastage
Can you define merge?
What is the difference between odbc and drs stage?
What is the difference between the local container and shared container?
Does datastage support slowly changing dimensions ?
Can you explain repository tables in datastage?
What all are the different way to run a job?