DSXchange

Sreenivasulu wrote:You need to use 'multiple lookup' stages not 'multiple datasets'.

Regards
Sreeni

Yes, that is certainly an option but then I am just replacing creating multiple datasets with as many lookup stages. Do you think there is some other options to avoid this? Thanks.

I need to do multiple lookups for different columns in the source against the same dataset. I cannot use the Range lookup since the values are not necessarily in a certain range. Do I have to create multiple datasets for each lookup? Or, are there any better options that I can avoid creating multipl...

We created a new project on our DS server (Windows Platform) where we have other existing projects. There is a SAP Pack which was installed initially and is visible in the older projects. When we created the new project, we cannot see the Pack in the Palette in the new project. Please advise. Thanks

Hi All,

How can I get the column description from the Table metadata in a text file or access the information for use outside of DataStage environment?

Thanks

Do we have different DS Server software to install on windows and unix or the same cd can be used for both platforms ?

Thanks

I read this in the manual for Parallel Jobs: "Parallel jobs must be compiled and run on a UNIX server, but you can develop them on a client attached to a Windows server." Does this mean we cannot create Parallel jobs when out DS Server is installed on Windows ? Or Do we need DS on Unix ? T...

I got all the information I need through everyone's comments. Thanks everyone and especially Ken for the elaborate description.

Thanks for the prompt responses.

The file gets over-written every time the job is executed. I am doing it even for huge data size since it enhances the processing time.

Do you think it is advisable?

Is staging data in a Sequential File a good practice?

In other words, is it resonable to create a sequential file during processing and use it to load the table or should we directly load the table?

I guess the amount of data can be a factor but am not sure if we have any related standards.

Thanks

New thread: old question.

How can we create an alias id for a job name?

I need to send the output of my DSJobReport function to one file rather than creating a new file everytime.

Also, does the alias id get input as an argument in function call?

Thanks

I talked to our DS Admin and asked the information about the server configuration and as has been mentioned, the answer to my question is dependent on the server info which means I cannot get a generic answer.

Thanks for all your comments.

Thanks for your comments Ray.

I realized there was some problem with the pathname for the directory. Its running fine now.

But I had another quick question. How can we attach an alias ID to my output filename. I mean it says if the job has an alias ID, the file would be named accordingly.

Thanks

ob_xxxxx..BeforeJob (DoJobReport): Failed to write file xxx.txt to directory \\dirpath\

I am getting this error while trying to send the information from DSJobReport(1; \\dirpath\;) to the directory.

The DS server is windows.

Thanks

thanks for the reply.

if you can direct me to any manual or specific tool that can give me that information, i will appreciate it.

What is our criteria for analyzing how many server jobs should we run concurrently on our server ?

Thanks