DSXchange

Have you tried to leave the four table names blank (Error 1/Error 2/Log/Work) and let DS use the default table names? I ran into several issues with entering in my own table names and they were resolved by just letting the default names be used.

Two issues and pretty sure they are related, but not sure. I am in the process of getting IBM PMR access granted, but wanted to ask the experts here. 1) I am trying to do a simple parallel job bulk load test with one record using Teradata Connector stage, variant 12. Source (tried Teradata table, da...

Have you imported the table definition for this source? I guess you must have. What are the defined data types for these columns. ... Yes, this was an import of physical data model from Sybase PowerDesigner. The defined data types for CITY is VARCHAR(50) and ACCT_PD_STATUS_CD is SMALLINT(2) on the ...

ray.wurlod wrote:In your design make CITY a VarChar with Unicode extended property enabled. ...

What do you mean by design?

When I run column analysis with a smallint datatype, I get this message only:
pxbridge: No design time SQL datatype provided for field ACCT_PD_STATUS_CD

Thanks Ray!

In this job log, I see the following messages that might help: pxbridge: No design time SQL datatype provided for field CITY pxbridge: The length of WVARCHAR column CITY cannot be validated because the database column is VARCHAR and character set conversion is involved. Inadequate column lengths can...

Are you really connecting the the source you THINK you're connecting to? ... In the Connections tab of running the column analysis, I have the Data Source Name listed correct. In the Director log, I see in the OSH script of the BaseProfile_ColumnAnalysisTask88423806 job with the correct TableName, ...

After closer look, the column analysis says Analyzed after the steps I took in previous post, but when I open the analysis I see that there are 0 total rows. I tried running with no Data Sampling and another time with Data Sampling of 2000. The table that I am doing analysis on has ~1000000 records....

I checked the tablespace and there seems to be sufficient enough of space allocated. In running the analysis and retaining scripts option on, I am able to see that the job successfully completes. However, the log says that it drops table/creates table/inserts 1 record successfully. When checking the...

Hi Stuart, I did check the user and it does have the correct credentials to the DB (which is admin rights). I did not check the tablespace size, but I am only running analysis of one column on a table that has only 10 records on it. There were no native database errors in the log. Thanks for your he...

This is the first time attempting to run column analysis.

The project properties for Analysis Engine tab was validated successfully and the Analysis Database tab/Validate Engine and Client Connection were both validated successfully.

I was able to figure out how to modify the Host and Database, but not the Schema.

I am trying to run column analysis in Information Analyzer on one column, but am getting the error "Failed to create FreqDist Summary for Error in post-process for DIM_TEMP". I have attached the SystemOut.log and systemErr.log messages. Any ideas on what is happening? Thanks! systemErr.log...

Hi everyone, I imported a physical data model using the Import Export Manager and the Server and Host information was not set at that time (default values were Unknown). I want to update this information to the correct information, but I cannot find any documentation on how to do this. Any suggestio...

Hi,

I am wondering if there is a way to turn off the zoned option on numerics in the CFF stage?

Thanks!

Thanks again! However, in the derived attributes there is no S either in my definition of PIC 9(8). The only thing that I notice is the zoned option shows up in the Parallel view of the layout. If the definition in the COBOL layout shows PIC 9(8), why would the implicit sign show up creating 11F?