BookmarkSubscribeRSS Feed
jplarios
Quartz | Level 8

Hi:

With DIS 4.2 is there a way to propagate column lengths? For example, I have a target with a length that is larger than the source since this was updated. We have about 200 jobs that need for the target to get updated. Without having to go into each job and delete target columns and propagate them from source, is there another way of propagating this without doing the latter manual way?

4 REPLIES 4
Halaku
Obsidian | Level 7

Updating table metadata in the Library should propagate into jobs automatically.

TEST:

1. Just create a simple job with two tables with extract>load transformation then run and save.

2. Close the job

3. Change the length of target table column in database and come back to DIS and go to table > right click > update metadata.

4. open the job. Then go to the table properties and properties of mapping columns in Loader (or any other transformation you like to test) and check to see the column length has changed to new value.

If your test is successfull then no harm applying to production.

Hope this helps.

jplarios
Quartz | Level 8

Halaku, thanks for the answer. What if you had hundreds of jobs where the source changed the lengths; do I have to go to each target table then open the job to update the job for each job? 

Halaku
Obsidian | Level 7

As you can see from the test that updating the metadata in the Lib cascades to the job(s) automatically. the only thing that remains is to redeploy those jobs, if they are scheduled, or you can run manually.

SAS DIS will try to strip the values to fit the target tables. I think you should do a test for the numerical values to be sure.

nar_sas
SAS Employee

In 9.3 there is a new tool in the tools menu called the column propagation tool.  It will support modifying/standarizing one or more metadata columns downstream of a source column for all metadata attributes including formats, length, and other attributes.  Lineage is also available from the tool to help identify where a column is used.  It is still a visual tool, but it does help automate the mapping process when columns change.  We have captured your request for additional automated tools to help with this task and will consider more features in this area in a future release.  Thanks for the feedback. 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1029 views
  • 8 likes
  • 3 in conversation