DSXchange

I am trying to develop a Parallel routine and I have this simple C program I tried to compile outside of datastage to make sure that it is working before I link it. Now, when I compile the program through putty it is saying CC not found but when I tried the exact same command on telnet it is working...

Hey All,

I am not able to see SQL server connectivity stages in the Database Pallette. Isn't it supposed to installed by default? Is there any specific process I have to go through to get these stage?

Thanks for the help

Nagin wrote:

ray.wurlod wrote:What are the properties involved here, particularly the Field Delimiter property?

The field delimiter is pipe character

Are there any other options or properties I am missing to specify?

ray.wurlod wrote:What are the properties involved here, particularly the Field Delimiter property?

The field delimiter is pipe character

I am facing a bit strange problem. I have a sequetial file stage that reads from a source. I have the Reject Mode option set to Output in the properties. One of the columns I am trying to read in is a Integer. And, when I have data for instance as 10.45 (which is a decimal) I want to be able to reje...

Ray, I was reading this article from a while ago. Can you throw some more light on why Stable Sort is slower than not using it ?? I take your word on this at the same time want to know more details in terms of architecturally why it is designed like that or why it behaves like that ? I need to take ...

In version 8x, If I use SetNull() function in the transformer to set the value of a column to null, it is setting the column value to "NULL" but not the actual null like the @NULL function in Basic Transformer.

Does any one know why? Or how to get the actual NULL inserted?

Thanks.

shershahkhan wrote: Mload stage:
1) Run in sequencial mode

Doesn't the number of sessions we specify in mload script represent parallelism???.

For such a big load of 750 million rows with pre delets I would rather take the multi load path rather than the Enterprise stage as I can do both in one mload script.

Got it, It was the FastExport problem. I found a fix from Teradata for this "Two byte" issue. DataStage job is working fine

Thanks for your help.

Hi, I have a Teradata fast export script that exports a table to a txt file. I am having problem to load this text format file into a dataset. This dataset is needed for certain lookups. The process that creates the dataset is rejecting some records saying that Delimiter for field not found. Any tho...

There is a before and after sub tabs in SQL tab in DRS stage, you can paste the sql for dropping foreign keys in the before tab. When the job executes, the sql in the before tab gets executed first and then the main sql for loading the table executes.

Can you post the C++ code as well? It will give us a better idea about the error.

Is there a limit as of how big a user defined query can be in the Teradata Enterprise Stage?

There should be an optional property Sessions per Player in the DB Options folder. I changed the number of sessions per player to 4, but I got an error saying maximum allowed is 2. The error I was getting saying 7 sessions were requested , but only 6 will be created, 2 per player for 3 players. So,...

ray.wurlod wrote:You need to increase either the number of nodes in your configuration file or the number of sessions per player in your Teradata Enterprise stage.

How can I increase the number of sessions per player in the Teradata Enterprise stage?