DSXchange

Hi,
The error you are getting tells me that there is some problem with the server name/ path provided. It can also relate to the login info being passed to the ftp stage. Kindly reconfirm that all the login details and ftp serever name/ url are right.
-Vikas

Hi, I would say you are doing right by using a Join stage instead of lookup since your reference dimension table also is quite huge. Additionally, you can sort the data prior to join stage on the key fields. Also, while the job is executing, look for the server resource utilization as in scratch spa...

Hi, There are two ways to do this, depending upon what you want to achieve. 1> If you only want to insert the records with new key values , and no updates if the non key column has changes, then use 'Upsert' Method and in Upsert Mode use 'User-defined Update only', and write the insert SQL in the Up...

Hi all, I have to import a file with unknown number of columns in a parallel job. By unknown # of columns, I mean that the meta data information may be different for the same file for different runs. If I use Seq file stage and enable RCP and only give one column name, it rejects all others. If I gi...

As told by Ray, If you are using 7.X version of DStage, then using a Long Varchar, can enable to read you using the 'view data' option and will also enable you to process CLOB columns. I have a similar case and I use LongVarchar(4000) for the same. For 8.0.1 , IBM has provided a patch to fix this, s...

Hi, It might have been a little late for you, but I saw this thread today while scanning through something else. One of the way ( a convenient one) to achieve round off in PX is using round_inf as an argument with type conversion function like DecimalToDecimal An example can be like this: DecimalToD...

Hey all, I m processing about 15 million records and there are multiple lookups for these records and datasets which in turn get created, The job is failing with the foll message: Could not map table file "/landing01/dataint/Ascential/DataStage/Datasets/lookuptable.20070508.5vnzzdc (size 727590...

Hey Ray, The parallel job is using a transformer stage to call a routine which in turn takes the parameter as hardcoded in the routine and triggers other job depending upon the availabilty of a key value. I tried increasing IPC interval and also enabling row buffer. Still sometimes it do fail. Is it...

Hi, The job calls a Routine using a transformer. It polls the database on a periodic basis- which can be as low as <1 minute. Now,once the job is triggerd after several polling rounds, it throws error in the transformer stage saying "Error 11 in GCI Link initialisation." Let me know y this...

I guess, U can chk dat in Administrator--> Env. variables

THanks for yuor valuable inputs.
I wil try out this and see ehether the purpose is solved or stilll some queries left..
~Vikas~

I need to run a parallel sequence which in turn runs few jobs & routines. The need is to run the job continuously & hence to poll database constantly. The problem arising is due to lack of options available in DStage Scheduler for continuous run, I need to use daily/every option, but this cr...

Hi,
Try to validate the input/output source n target files or tables before executing d Job. It has to do with the credentials specified. U can use preview data tab to do this..
Try to run then..
~Vikas ~

Thanks Ray for ur inputs, I m casting it as a longvarchar, But the problem is All the Blob records containing differnet XML files are parsed simulataneoulsy and using the XML input stage I m not able to propogate the id column for a particular blob record with it. Is there any way to resolve this? V...

Hi, 1)I want to parse xml files stored in a blob column in a database table along with its id which is in second column for the same record. When I am using XML input stage, I m able to parse the XML but cannot propogate the ID column without which the parsed XML defies meaning. Its giving an error ...