DSXchange

So, it seems like there is no way i will be able to auto generating a job with a sequential file as the target stage or in fact for that matter as a source stage if i am reading data from a flat file.

Is this right Ray ?

Thanks

In FastTrack, it is fairly easier to import the metadata from the data sources and use them as either source or target in the mapping specifications. I am stuck when it comes to generating a mapping specification where the target needs to be a sequential file. Though i use a configuration for sequen...

No, these loads don't write to the same DB at all - totally different DB's

Hi, Have a weird issue. We have one DW load that runs a set of server jobs that runs couple times of day (total run time is only 11 min) and another load that runs tons of parallel jobs (total run time is about an hour and processes lot of data). Normally when submitted by itself, both loads perform...

I think this is what made this work

zip -j #TgtLoc#/ZipFile.zip #TgtLoc#/*

Thanks to all for your suggestions. Appreciate your time.

OK - i think i see where it writes the zip file by default - its in the Project directory.

Craig,
If i don't do a "cd" where will the zip file be created. i can take it from there as well but when i ran with

zip zipfile.zip #TgtLoc#/*

then it executed fine, just didnt know where it created that zip file - i didnt see it in $HOME or $DSHOME or /tmp

Balu, the reason i need ZIP is coz these are csv files that i have generated on LInux, but need to email them to users who will open them in windows. The zipped file when extracted looks good, i can open it fine in windows. The only issue what i am having here is that when i try to extract the zip f...

it gave me an error with the -R

"zip error: Nothing to do! "

Thanks Craig,
I did remove the -r but the output zip file still remains the same - i wonder why then.

I have a job sequence, that has a series of jobs to write to set of files and then one execute command stage to zip them up (in LInux) with this command zip -r #TgtFileLoc#/Files.zip #TgtFileLoc#/* And then another notification activity to read this zip file and email it as an attachment. All of thi...

Hi, Was wondering if anyone had attempted importing code from a later version of Datastage (8.X) into earlier versions. My scenario here is that we have a month of parallel run in production - with both V8 and older V7 to do our data testing and performance testing etc. And here come some emergency ...

We have jobs that have the Oracle Stage (target) that are in truncate-insert mode and have the index mode = Rebuild and the Add compute Statistics option set to true. Normally in production, we have the stats on the tables locked and can be only analyzed using the dbms package statements (with the f...

ds_search2008 wrote::D Solution: Tried using DS_NO_PROCESS_METADATA environment variable and set the value to 1. This solves the problem. :D

Thank you all for your valueable time and replies. :D

Where do you set this variable? in administrator? or in dsenv?

Thanks Ernie and Ray, I have now figured it out. We had imported some tables into DataStage using ODBC and some using Oracle Plugins. I was struggling with the ones created using ODBC. Now i have tried doing the same with the table definitions that were imported using Oracle Plugins and now it is vi...