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
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 the flow of loading data into fact & dimensional tables?
Can you implement SCD2 using join, transformer and funnel stage?
What is the difference between account and directory options ?
How and where you used hash file?
What are the processing stages?
What is aggtorec restructure operator?
how to delete one row in target dataset
how do u catch bad rows from OCI stage? And what CLI stands for?
Define APT_CONFIG in Datastage?
Define ds designer?
What is process model?
How do u convert the columns to rows in datastage?
How complex jobs are implemented in datstage to improve performance?
What are datastage sequences?