Interested to Buy Any Domain ? << Click Here >> for more details...
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
Define Merge?
What is apt_config in datastage?
What is a merge?
What are the different type of jobs in datastage?
What is the purpose of interprocessor stage in server jobs?
how many rows sorted in sort stage by default in server jobs
What are the functionalities of link collector?
How to reverse the string using unix?
How we can covert server job to a parallel job?
Where the datastage stored his repository?
Differentiate between data file and descriptor file?
What are sequencers?
What is a quality stage in datastage tool?
Is possible to create skid in dim,fact tables?
What are system variables and sequencers in datastage
