DSXchange

Lately our jobs with Aggregator stage started failing with Below errors: "sendWriteSignal() failed on node <Server name > ds = 1 conspart = 0 Broken pipe" "Fatal Error: Unable to allocate communication resources" "Premature EOF on node <Server> Socket operation on non-socket...

Hi I am using below unix command to zip the reject files in DirReject directory which have record (line) count >1, It works fine but the files are having their absolute path along with them, Can you please help me get rid of the absolute path and have just file name. zip DirReject/Rejects_zip `wc -l...

Hi I have a file list which contains list of files to be read using sequential file with same metadata. Using file pattern, Can I just use the file name which contains the list of files to be read. and extract the data? file_list.txt --> datafile1.dat datafile2.dat In other words, I have to use only...

Thanks for the response ray, You are saying we can import metadata from fixed width file.. Can you please tell which option I should select while importing.. I tried seq file definitions did not work.
Thanks again..

Hi, I have to read a fixed width file with some 800 fileds, But we only use 5 fileds in our DataStage job. I was wondering if it is possible to read only those 5 fields from my input file? If we can not read only 5 fields, Can I import the metadata from fixed width file? Please advise. Thanks in adv...

Abby,

Can you please elaborate how you resolved this?

Hi, I was doing a full extract from table and writing to a dataset, running the job on 4 node config file, But when I try to view the data using dataset management, Data is going to only one node??, I was trying to understand If there was any setting that I was missing?? Please help me understand th...

Hi, I want to understand how hash partition works, Here is what I am confused with, If i use hash partition, records will be partitioned based on the hash key provided. records with similar hash values will go to one partition, lets say I have 20 thousand partitions, how they are assigned to each no...

Hi,

I have a requirement where I have to Extract from Oracle Partitioned table and load into Oracle partitioned table, Please advise what need to be set in Oracle enterprise stage.

Thanks for Ur help..

yes, I changed it lookup failure --> reject, and works fine. failure was not handled earlier.

I exactly did that,
used loop counter inside user variable, like if counter 1 email1 --> attachment1,
counter2 --> attachment2.. so on, coded in the derivation part of the user variable stage (awesome stage in sequence jobs)
thanks a bunch guys..

Sorry, I did this in Uservariable stage in seqence job.

Thanks.

I did this using OCONV(@TIME, "MTS").

Thanks guys.

I have to compare a hard coded time in hrs with current time in hrs. I think i can use @TIME, but dont know xactly how to use, can you guys give the syntax for @TIME plz,
your help is greatly appreciated..

Best way of doing it is truncate using a shell script, and just use dummy update in next job in your upsert, call both in your seq job.(Keeping in mind you have to capture the rejects).
Seq_job (Exe-command -->Job_activity).