DSXchange

Happy new year to all you guys. Had a beautiful year, expect even better the following....
May this year bring increase in knowledge and wisdom, health and o yea, lots of wealth...
Enjoy...

Do an exact search on 'Not enough space'.

O what the heck, its close to new years, ill give you the solution in a silver plate , but dont get used to it. Run this command on your file sed 's/~/,/' myfile.txt | awk -F"\," '{for(i=2;i<=NF;i++) print $1,"~",$i }' > NewFile.txt Your task: Study it and tell ...

Oh comeon, i was just kidding. You did pay for it, you are a charter member arent you
Enjoy.

You can define as many parameters in as many jobs. Say you have job X, job Y and job Z. Job X has four parameters: x1, x2, x3, x4 Job Y has two parameter: y1, y2 Job Z has one parameter: z1 You have a job sequence MasterOfAll controlling the above three jobs. In the job properties of MasterOfAll, yo...

Did i hear V8 engine. Count me in the club...
Thanks for sharing that info with us Ultramundane.

You can put it anywhere. For now, take a back of the dsenv file as i suggested earlier and put that line at the end. Save it and then execute it.

Hi all. I m running a job.which load data to Teradata table. But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows. so plz tell me whats reason? Check the director. It seems that the rest of the data got rejected. Look into the Director's log for this job. You will see...

Exellent advice.

See if this posthelps.

You are correct. It needs to be parsed. Can you do this in server. If you can its very easy via a small routine. Otherwise something like awk will be of help.

First you need to perform vertical pivoting on each input. Once you have that done. Then store one input into a hashed file. Let the other be the input. Do a lookup on your first column and then concatenate the records together with a pipe in between.
Search the forum for vertical pivoting.

You mentioned that you manually deleted the child files. I just wanted to point out that you should not use the unix rm to remove any .ds files. Thats just a descriptor file. It needs to be removed using the orchadmin rm command.

Write it in user defined sql. The key of the hased file will be whatever key is present in the source. In this case it will be nation key as thats whats present in your Customer table (source). Get all those columns from your query that you need in the output, and the same will be the metadata of yo...

Is this server or px?