Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is a datastage job?
What is size of a transaction and an array means in a datastage?
Explain usage analysis in datastage?
What is the command line function to import and export the ds jobs?
How a source file is populated?
I have a few records just I want to store data in to targets cycling way how?
What is a folder? Difference types of stages?
How many types of views are there in a datastage director?
What is the difference between validated and compiled in the datastage?
Define APT_CONFIG in Datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How do you run datastage job from the command line?
Why fact table is in normal form?
Name the third party tools that can be used in datastage?