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
How many types of stage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is use of SDR function?
How a source file is populated?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the functionalities of link collector?
How one source columns or rows to be loaded in to two different tables?
how many rows sorted in sort stage by default in server jobs
How many types of views are there in a datastage director?
What is meta stage?
How many areas for files does datastage have?
What are system variables and sequencers in datastage
What is data partitioning?
How and where you used hash file?
Differentiate between Join, Merge and Lookup stage?