DSXchange

Use a job sequence, and call your job using a job activity. Write a routine/script to get the value from the file, use a user variable/or command activity before the job activity calling your job. Pass the user variable, which is your date time stored in file, to a job parameter (say DTTM). now you ...

Hi Barbara, If you can use a a "USer Variable" stage followed by the Start Loop activity and execute the command ls -lt|head -1... you should get only one file name from the list of all files. For getting the file name you may have to write a small routine which calls DSExecute command and...

I never thought about this scenario before.But, my guess would be it should discard the file.

Need to simulate it to get the confirmation though.

if i have understood your question correctly, you are trying to pull out data from the first file depending on values in lookup file (e.g. 'ab'). how many columns the first file has. if its limited (3,4) you can have a join stage joining both the files with equating lookup file column with all the c...

Hi,

I had a problem with a header\trailer in the past few days and might be able to help out, but am not quite sure what exactly is your problem there.

Regards,

Novak

Never worked with Oracle..but read somewhere that Oracle Load stage uses sqlloader with DIRECT=TRUE by default.

It looks I have permission to write in DS_STAGETYPES. Following is the output of the ls command. -rwxrwxr-x 1 dsadm dstage 26624 2008-05-05 14:15 DATA.30* -rwxrwxr-x 1 dsadm dstage 10240 2008-04-24 12:22 OVER.30* -rwxrwsr-x 1 dsadm dstage 0 2007-08-28 17:22 .Type30* Can there be any other reason? Th...

Hi All I am trying to create a Custome operator (CustomPX_1) in DS Manager. While Saving the detail it gives the following error. Record CustomPX_1 on file DS_STAGETYPES cannot be written Is there any issue with the access for my user ID. Do we need manager access for creating New Parallel Stages?

ray.wurlod wrote:It's entirely appropriate to server (on UNIX).

Hi Ray,

Is this because the file name is going as a part of argument to export operator in PX?

Then, just wondering whether Server uses something like touch <file_name> for creating the target file?

Hi splayer, 1.Using Reject Link Inside Container: First you exactly need to know what you are looking for. If you are looking for both 'Condition Not Met' and 'Reject fail' records to go in the reject stream, use both condition and Lookup failure constraints as 'Reject'. Otherwise if the intention i...

In server you may not be able to change performance, by merely changing parameters.

To take advantage of the number of processors, you may decide to partition the data using Link Partitioner.

By checking IPC and increasing buffer space, you can take advantage of pipeline processing.

Hi Bharat,

Most of the datastage errors are orchastrate errors, as DS EE runs on Orch engine. So if you find this forum with keyword Orchastrate, you are going to end up with a sea of topics.

More narration of the situation/job design is required to understand the problems you are facing.

Why would you like to set the job status in Job activity? If you want to pass different statuses, when the Sequence is called at separate instances, you can make a provision of a Job Parameter in the job and write a job control routine or before routine to update the job status to the value in the p...

Thanks Ray!

Hi Ray, I did SELECT * FROM DS_JOBOBJECTS WHERE @ID LIKE '%<JobId>%' AND OBJNAME LIKE 'ROOT%' The answereset is Object type........ J Object record id... 13 Object record name. ROOT Description........ There is not Date displayed here. Again, I couldnot find any Date column in DS_JOBOBJECTS table. A...