DSXchange

seanc217 wrote:How about writing a Korn shell script to capture the size?
You could do an ls and pipe that into awk and capture the file size there.

But its for windows.

What is the total volume of records.
View data will show you partial data. Is server and PX server residing in the same machine.
Try to run the job in sequential mode. Try to change the configuration file and make to on the node where server job runs.

Iam still thinking a way to capture the file size (alone) from dos prompt.

Ray- Is the F3 pointing to NAME of DS_JOBOBJECTS? And Once DS_JOBS is updated, DS_JOBOBJECTS need to be updated with new name ie., UPDATE DS_JOBOBJECTS SET NAME = 'prefix<<OldName>>' WHERE OBJNAME = 'ROOT' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<< NewName >>';

By default PIVOT runs in Sequential mode.

As per the suggestion, try with the adminstrator user id.

Just do a search on generated Job control on the job properited tab, whether the particular parameter still present. If so you can find where it resides.

That depends on the field OBJNAME. Job has OBJNAME as ROOT.

But if NAME in DS_JOBS get updated, shouldnt the NAME in DS_JOBOBJECTS get updated automatically?

Have you tried the Other wise option?
Try the reject link on the same API stage.

What happens when you write into a sequential file without any constraints given in the transformer?
Is it single soruce into 3 file or 3 source into one transformer and again into three file?
Any change of the data being fed in to the hash file is different from development to the new environment?

What is the change you made and what is not getting reflected?

LIST DICT DS_JOBOBJECTS will give the full list.
Though it doesnt show during select * from DS_JOBJECTS or LIST DS_JOBOBJECTS.

Alternativly you can try to make readonly particular to category as follows.



Where the category is what need to converted.

Rather try to create a new project with protected mode and give access to the analyst.