Hi All, I was hoping someone would be able to take a look at my incrementalload scenario below and advise why my script for it is not working please? My scenario is: I am l...
Hello Friends, I have one oracle table. in that table there are few columns for example. ID (Number) Name (Text) Description (Text) RowVersion (Number) Now i want to implement incrementload...
...ertain date as incremental to the previous load. The step I followed is 1. Stored the previous load as a qvd 2. Load the previous qvd 3. Get max date from previous qvd 4. Load the new data (csv f...
Hi I have following sales data going back to year 2014. The actual model i have takes an hour to reload as it reloads all the data. I want to reduce the reload time by applying incremental...
Hi guys, this is breaking my head, I'm creating an incrementalload, but I don't know what's happening, once I concatenate the old data using not exists, the old data is reduced to 1 line per field u...
...inutes... and it is a hug directory"it takes over 8 hours to finish loading". Is there anybody can help me in setting incrementalload so I dont load all the files again. It will be great if i can load t...
Hi, I am using below script for incrementalload. Issue is happening while checking for Modified records. I have verified date formats of 'modified_date' column from database and last update v...
Hi, I am trying incremental data load with a sample data. It gives me error when i load the data. Can someone check if the sequence of steps are correct and what is the error in the s...