SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Changing Table metadata of LASR server table

Reply
Contributor
Posts: 31

Changing Table metadata of LASR server table

Hi, Can we alter a table Metadata of LASR In Memory Table? e.g. Say changing a length/type of the column Nikhil
Super User
Posts: 7,782

Re: Changing Table metadata of LASR server table

Posted in reply to nikhil_khanolkar

When you change the size of a variable/column, this impacts the structure of the whole file, record by record. So it always implies a rewrite of the whole table, either on disk (Base SAS) or in memory.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New User
Posts: 1

Re: Changing Table metadata of LASR server table

Posted in reply to nikhil_khanolkar

In my case a XML column trows of the SQL Instance CDC script to create the mirror table and adds the column called unused_1.
Here are the steps that I did to get it to work.  Pega Training in Chennai

1. Create the table in the CDC Designer console as you usually would.
2. Copy the CDC instance deployment script (from the right of the screen)
3. Remove the table that is being dropped when data is added.
4. Copy the table creation and CDC section from the script, remove the unused_ column, and execute.
5. The mirror table is now created and CDC is activated on it.
6. Check that the table is in the CDC designer.   VMware Training in Chennai
7. Add data to the oracle table and see the changes being recorded.

Do more testing of data being moved.

I hope this helps! I took me quite a while to figure this work around out and I hope it will be fixed in future versions.   PHP Training in Chennai

Ask a Question
Discussion stats
  • 2 replies
  • 285 views
  • 0 likes
  • 3 in conversation