DSXchange

How can I store a delimited string as a variable length vector for vector matching?

Example source string (delimited by pipes)
'2'|'4'|'22'|'22'|'19'|'8'

Hi lkevin1210, I have experienced a similar (if not the same) issue. Making a change to a parameter set structure such as changing default values and adding or removing parameters do not reflect in the job until the designer is closed and relaunched. This happened a few months ago and from memory I ...

Thanks Ray.

There are a number of developers that have clients installed on their workstations so I wont be able to ensure that client copies are always locked.

I was hoping it might be as simple as setting a "locked" flag on the server side.

Cheers.

Hi, I have a lookup table define that is being used for a number of QS Rule Sets that I want to remain static. Is it possible to lock these lookup tables in much the same way that the provided Rule Sets have lookup tables are only available to open in view mode? For example the provided AUFIRSTN.TBL...

I forgot to mention that we do have IMAM, and I have been able to import Hadoop tables and Files. However, without IGC i am unable to test if the lineage is automatically discovered between the Parquet files and the Table definition.

Hi, I was hoping that someone has had experience cataloging Hadoop assets in IGC and provide feedback on how easy/painful the process was. Currently I am working at a site where they decided to install the minimum to use DataStage and QualityStage, even though the client is entitled to install the e...

If the data isn't suited to partitions what is the point of using a checksum for partitioning? For example if you want to partition on say a gender code which potentially only has two distinct values and you checksum on the gender code you will still only have two distinct values produced from the c...

@ chulett : No progress so far. My next thought is to generate some test data based on the JSON schema. This is where I run into my next problem, the schema is full of cascading references. @ eostic : I thought someone would comeback with the trying to find a "complete" JSON file. Ive been...

Have you considered the istool command to manage your IA assets?

https://www.ibm.com/support/knowledgece ... mmand.html

Cheers,
jneasy

Hi, I have been attempting to parse large JSON files (+200MB) that are provided on a daily basis using the schema provided. I do know that in the Hierarchical stage the assembly editor can infer the schema by just importing the JSON data file,I have been able to parse a file based on this approach. ...

Hi Developer9

In the past I have created a server routine that would loop through all the jobs in the repository and purge the logs manually.

Cheers,
jneasy

I tried what you suggested asorrell - the peek named the column without quotes.

As a work around I renamed the target to an appropriate column name without double quotes then once the table was loaded I renamed the column back to the double quoted column name.

Cheers,
Joe

Hi, I am trying to rename a field using the following MODIFY spec. "MODE":string[50]=string_from_ustring(MODE); But I get this error "Error parsing modify adapter" I have a generic job using RCP to SELECT * from a DB2 then load into Teradata DB2 --> Modify --> Teradata The Terada...

Hi, Does anybody know if in the Quality Stage PAT file if a Pattern can be generated from a variable? essentially I want to do the following; [ temp ! = "" ] PATTERN temp --> temp_pat I know that PATTERN only works on active tokens but the problem is I have already retyped them to 0. Any i...

Thanks Ray, I did notice the records for active stages.

I guess I will have to investigate it a bit furter.

Cheers,
Joe.