DSXchange

Below is the line from the Server JOb Developer Guide/HASH file Stage

The primary role of a Hashed File stage is as
a reference table based on a single key field.

I think its says about the primary function, i think then i have mistaken it.

Hi, I have a requirement that i want to join 2 data files having multiple keys a primary key. I have read posts suggesting make one file as HASH and then joining with other file but as per documentation HASH file can have only 1 column as key. So how would i achieve this? Secondly, Whats the best pr...

Hi All, I am facing the same problem and i implemented the suggestion of breaking the job and now FastExport Stage is running separately and so as multiload but i have noticed one thing that even the fast export is writing data to a separate file but still the data is coming on link as well why is i...

I gave the complete path in the command stage and still did not work then i gave path in shell search path and it worked. why it is so?

ACtually my C pogram accepts no param, strange enough but i have solved the problem by adding the path of the C program into SHELL SEARCH PATH. i have no clue why i did that can anyone please explain this to me that whats the significance of this ENV variable and why did my command stage worked afte...

All, I was facing the same problem and i posted the same problem on the forum and was almost stuck for last few weeks, finally i have managed to find the solution, this error comes due to the fact that the SHELL SERACH PATH Environment variable of DS did not have the path for the library i was compi...

Hi All, I am calling an exe file from command stage and when i execute the job it returns an error Command Failed to Execute %1 WHen i run the exe outside from DS it runs perfectly. the program is a C exe which manipules some data and generates a text file to be loaded into DB. Thanks in advance.

Shoudl not be a problem as one of my windows xp system DS is on D drive and Visual C++ is on C Drive.

Secondly i think you would need Visual C++ .NET as its specifically mentioned in the intall document.

We have used this approach in few of our projects, there is one table which contains the table name and the max value so far of the key column an after every load we add the current count of the loaded value in that metadata table, and when we want to add new rows to the target table we get the late...

Hi all, After fighting with the installation of 7.5x2 finally i succeeded in installing the verison but the OS is windows 2003. Here are the details, i followed exactly the instruction given in the installation document except one thing, when i installed the VC++ .NET i avoided any spaces in the ins...

Yes i did install the VC++ .net 2003 Compiler installed downloaded from MS Site. And i have also found out that if the compiler installation has spaces in path then the Wc++ and /MD errors come and i re installled the compiler and got rid of those error but the data truncation warning still exist, f...

Eric, The compiler is available coz when i compiled the c Code from Command Line i get the APT_INT64 Assignment Error. Now after doing some Path Adjustements now i am getting the other errors i posted in my other Post http://www.dsxchange.com/viewtopic.php?p=150591&sid=c7f4b40fb6bf168ce545e8c121...

Hi, When i am dtrying to compile the transformer i am getting this Error. Can anyone please explain what i am doing wrong here. I am Clueless :cry: Output from transformer compilation follows: ##I TFCN 000001 10:35:10(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2...

Thanks Ray, I'll read the chapter

So another question,
Can i change the paths of DataSet and Scratch for each node differently, i mean for node1 Drive C,node 2 Drive D and So on?