DSXchange

Hi All,

I would like to know whether there is any Universe table in PX that stores the partition details stage wise?

Regards,
Sai

Hi, I hope the code below can help you. Reading Parameters from a Parameter File The Below mentioned code illustrates how to read the following parameters from a parameter hashed file and log information about the directory paths in the log: - DIM_DSN - DIM_UID - DIM_PWD - STG_DSN - STG_UID - STG_PW...

Hi,

I was narrating the experience we had when using the 6.x version of the server. We had observed a couple of bugs when you select the option "Creat File" and the performance use to degrade.

Sai

Hi,

Sory for my previous post. Just select "Clear File" and observe. "Create File" option may degarde the performance at times

Sai

Hi,

Just Uncheck "Clear File" and observe. "Create File" option may degarde the performance at times.

Sai

Hi Ray,

Very sorry for the post. May be was in my sleep while replying I actually meant get the count of the rows in the aggregator and put a filter in the Transformer stage having count(1) >1.

Extremely sorry

Sai

Hi,

If you want to capture the duplicate rows, you can always aggregate the data based on the key and put a filter having count>1 in the aggregator. In terms partitioning the data, i think you can partition the key based on hash.

Sai

Hi, If you dont have the option enabled, it will not load the entire hashed file into memory. It will read from the hashed file row by row. However, if you have a large amount of data to do lookups on and if you can create an intermediate table in your database then load the data into a table and do...

Hi, If i understand correctly you want to do a look up in a server edition. In a server edition you can do a lookup using only a hashed file. Pre-load into memory: Once enabled the hashed file will be read into memory once the job is run. It can certainly improve the performance. However, if you are...

Hi, Lookup Stage: You don't have lookup stage in server. In server you do Lookups using Hashed files. In parallel version you have a lookup stage for performing lookup's. Sorting Stage: As the name implies, it is used for sorting. DataSet Stage: The Data Set stage is a file stage. It allows you to r...

Hi,

To set the Environment variables you need to log onto the Administrator. Log onto the Administrator, Select the Project->Properties-> Environment Variables. Over here Select Parallel and point the variable APT_COMPILER to the location where you have the C++ compiler

Sai

Hi,

I have installed the server version on my laptop. As Vincent pointed out, give the Host System as 'localhost' and if you have any "User accounts" created on your laptop, give the accounts user name and password.

If you have no User accounts then select the Omit option

Sai

Hi All, I am still not clear. Assume that i have created a parallel job to read data from a file and to load into an oracle table. Now to load into the database can i use the Oracle OCI Stage or this stage is only applicable for sever jobs? If you are using a parallel job, then do you always have to...

Hi Man,

Thanks for the reply. In continuation, can i use an OCI stage in a parallel job , if i prefer to load data sequentially?

Sai

Hi All, I am new to parallel and learning most of the stuff by reading the documentation. I would like to know the difference between Oracle Enterprise Stage and Oracle OCI Stage? Is it like Enterprise can be run in parallel and OCI in sequential mode? Could any one plz explain me the difference? Sai