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
Which warehouse using in your datawarehouse
How complex jobs are implemented in datstage to improve performance?
How will you move hashed file from one location to another location?
What are routines in datastage?
What is a merge?
Can you filter data in hashed file?
What are some prerequisites for datastage?
What is the difference between an operational datastage and a data warehouse?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the repository tables in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Have you used Unstructured data?
Can you explain players in datastage?
What are the types of jobs we have in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
