Interested to Buy Any Domain ? << Click Here >> for more details...
what is initial load and incremental load
- 3 Answers
- 32041 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikandan
The only difference that the inital load jobs were set to
first truncate the tables and then do a complete load and
the incremental load was set to insert new rows and update
existing rows for DIMENSION Tables. Facts jobs were same
(truncate and complete load)
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / 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 |
Answer / saidarao
1.waht ever the data in the source is called intial load
(the data is already loaded in target is called before data)
2.the data which is generated after the data already loaded
is called after data
(the changes done in source are going 2 refresh the target
that is called incermental load)
per day-360 times
| Is This Answer Correct ? | 3 Yes | 1 No |
Differentiate between odbc and drs stage?
how to create document in datastage?
what is the definitions for Datawarehose and Datamart?
What is the difference between validated and compiled in the datastage?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
Why fact table is in normal form?
What is a merge?
How one source columns or rows to be loaded in to two different tables?
What are system variables and sequencers in datastage
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
Whats difference betweeen operational data stage (ods) and data warehouse?
Why do we use exception activity in Datastage?
Teradata 
