Glad I could be of help. If you have any concerns I would look at this log: root_folder/sas/viya/config/var/log/svi-indexer/default/sas-svi-indexer_xxxx.log or take a closer look at the tables in the postgres schema "svi_indexer".  ... View more

Hi  1. Use this example program: ".../sas/spre/home/SASFoundation/ucmacros/amlcoresrv/fcf_post_index_etl.sas" combined with this docuentation: https://documentation.sas.com/doc/en/compcdc/8.2/visgatorag/n1qumm1bvz5hi5n1c6qp962o725i.htm and you should be able to create a batch job that does an incremental update. See screenshot of a program (part of it) that I made.  2. Might not be needed if you get above to work, very fast update. Otherwise you can probably make a query to the e.g. indext.dh_batch_job_execution table to query the status of the index job and trigger the next job based on the result.    The Zencos team can help you if you need more guidance.  ... View more

And signing up for next event 7/12 I just got a confirmation that I have signe up for "An Introduction to SAS Customer Intelligence" - not the AML event I actually signed up for.  ... View more

Hi, FYI - I never received neither an invitation or reminder to above event after i signed up and got the confirmation (hence totaly forgot about it), you might want to check this, probably not the only one seeing the other comments here.  ... View more

The register link takes you back to the first page, not possible to register as of now, this migth not be intended (or is it to early to sign up)? ... View more

Yes, please share the mapping tab. Also, using datetime values is fine, I always use that since we could have several updates within a day. Another point, use current indicator (or version number), so sas can compare the business key of the source row to the business keys of the current row in the table. Your business key should probably also have a unique definition, since you are using retained keys you should add your end date to the business key tab. Try this and let us know how it works. ... View more

I don't have access to test this myself, but I do believe this will work for you. The record has changed and the old can be considered to not exist in the source (even if the key is still the same). ... View more

Hi, if I remember correctly you need to set the following option to yes:     Regards, Erik Meyer       ... View more

Hi Lyanne,   Here are the link to the coursedata, and some instructions on how to set this up, I did this on my own laptop, worked fine. Good luck.   https://support.sas.com/edu/OLTRN/EDQ26DM1/coursedata.zip   Open this zip file and extract the folder to a location where you have Write access. The ZIP file has a parent folder (dqdmp1) with two child folders (data, solutions). The data folder has five subfolders: Copybook Text Files MDB Files XML Files SAS Datasets The solutions folder has the following items: two subfolders (CaseStudySolution, files) a repository file (solutions.rps) several QKB scheme files (with an extension of .sch.qkb) three backup data ZIP files Establishing the Data Connections The course assumes that two data connections are in place. Follow the steps below to establish these connections in your environment. Access DataFlux Data Management Studio. Click the Data riser bar. Right-click the text Data Connections. Select New Data Connection > ODBC Connection. In the ODBC Data Source Administrator window that appears, click Add. Scroll and find Microsoft Access Driver (*.mdb). Select it and then click Finish. Enter dfConglomerate Gifts as the data source name. (It must be this exact string for the solution files to work.) Click Select in the Database area. Navigate to <your unzip location> \dqdmp1\data\MDB Files. Click dfConglomerate_Gifts.mdb > OK. Click OK to close the ODBC Microsoft Access Setup window. While still on the System DSN tab, click Add again. Scroll and find Microsoft Access Driver (*.mdb). Click it and then click Finish. Enter dfConglomerate Grocery as the data source name. (It must be this exact string for the solution files to work.) Click Select in the Database area. Navigate to \dqdmp1\data\MDB Files. Click dfConglomerate_Grocery.mdb > OK. Click OK to close the ODBC Microsoft Access Setup window. Click OK to close the ODBC Data Source Administrator window. If necessary, click Data Connections (from the Data riser bar of Data Management Studio). Select View > Refresh. The two new data connections should be available for use. Verify that the dfConglomerate Gifts data connection has five tables and that the dfConglomerate Grocery data connection has two tables. Regards, Erik Meyer ... View more

Hi Karuna, you should do some testing first. If you create one big table in EG, and use a datasourcefilter in VA on the LASR table, and it takes more than ca 7 seconds to open a report (more than that, and the report users are going to be annoyed) you should create 5 smaller LASR tables. I don't remember the source, but reasearh found about 7 seconds to be max for opening a report before users have a negative experience, so I always try to have that as my limit. The alternative then is to add more hardware.   Regards, Erik Meyer ... View more

Hi David,   It really depends on your hardware, but 23 millions rows (5gb) is not that much. I once loaded a table that was around 115gb (oracle) and it took about 15 minutes (we had decent hardware). Have you tried to load a small table just to check that your server and library definitions is working? I would also take a look at the options in the library statement to see if you can optimize the query a bit. Take a look at the SAS Acess documentation (and google to find more specifc papers).   http://documentation.sas.com/?docsetId=acreldb&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=en   Regards, Erik ... View more