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
Name the command line functions to import and export the DS jobs?
How and where you used hash file?
project Steps,hits, Project level HArd things,Solved methods?
What are the types of containers and how to create them?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Why fact table is in normal form?
What are the types of containers?
Can you filter data in hashed file?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Is the value of staging variable stored temporarily or permanently?
What are transforms and what is the differenece between routines and transforms?
What is the difference between server job and parallel jobs?
client know skid info?
Describe the main features of datastage?
Difference between sequential file and data set?
