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 third party tools that can be used in datastage?
What are datastage sequences?
explain about citrix scheduling tool in datastage
What can we do with datastage director?
How many types of sorting methods are available in datastage?
Why fact table is in normal form?
What are the processing stages?
Where do you see different stages in the designer?
What are the types of containers and how to create them?
What is ibm datastage flow designer?
What are the different plug-ins stages used in your projects?
What are system variables and sequencers in datastage
What all are the different way to run a job?
What is the use of hoursfromtime() function in transformer stage in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
