DSXchange

srinivas.g wrote:for catageory wise export through unix is not possible.
U need export job by job.

Not sure , but I think it's possible, there are some optional [option] to export category wise.

DS experts can you please add input to it?

Regards,
Akumar

hope you are using orchestrate to load the metadata defination, check if not

dsimport.exe /H=<hostname> /U=<user> /P=<password> <project> <path>\job.dsx



dsexport.exe /H=<hostname> /U=<user> /P=<password> /JOB=<job> <project> <path>\job.dsx

shankar_ramanath wrote:Hi,

I would like to get the list of all parallel jobs in a job sequence. Is there a programmatic way of achieving this objective?

Thanks,

Try Usages analysis

Hello, Can any one let me know How to move environment variables from DEV environment to TEST environment? is there specific folder or any file also need to be moved to get environment variable moved in other environment? Let me know , if any more input is required. Any input on above concern will b...

ray.wurlod wrote:

Akumar1 wrote:I have an urgent issue.

DSXchange is an all-volunteer site whose members post as and when they can. We don't do "urgent".

If you need urgent answers, sign up with your official support provider for premium service. Learn the true cost of "urgent".

Point taken..

chulett wrote:That's pretty common Oracle behaviour in that situation and as Arnd notes, you can use that $APT variable to override it. ...

All,
It worked,
thanks Again!!

Hi, Actually we are trying to insert space value in the oracle table, but it is taking as null only. Let me explain the issue: We have our source as flat file which has a string column (Status varchar2 (5)) which is coming with spaces as value for some of the record, see the below example: And I nee...

Hi All,

Can any one tell me how to create a schema file using sequential file stage "with an example" in datastage PX?


Your response will be highly appreciated.

Regards,
Akumar1

We have a requirement like this: The first job extracts records from a data source and stores it in a flat file. The second job extracts these records from the file and performs transformations and then writes the transformed records to another flat file. Third job extracts the records from the last...

Hi, hope information provided by "chulett" is more then enough.i would like to add one more thing that is whenever you creat a hash file, by default it creats TYPE30, DATA30 and OVER30 files.which you can't view because the format is binary. Regards, Akumar1 1. Yes, the default type of has...

Please follow the below steps for creating the hash file and reusing it as look-up 1.take-up either text file or relational database as a source, take-up hash file stage as a intermediate target which you want to take as a look-up purpose. 2. Check the create file option. 3. Specify the path for the...

You need to create the hash file for populating it with data. Once the hash file is created you can use the hash file as a look up(specifying the same file name in input and output) subsequently based on the key value you can pass the corresponding value to destination database. Regards, Akumar1 Hi ...

since it is windows environment,i don't think that ((sort -u)) command can be used.because the option in enabled only in unix environment. Regards, Akumar1 In the input sequential file stage filter option use (Hopefully you have MKS Toolkit or similar installed) sort -u and then use pivot stage to g...

Hi dear All, When we are using column import stage and when we define any column datatype as numeric, integer or decimal and null type condition defined, we are getting below error message in the log. ColImptrTdr,1: Field "User_Zone" has import error and no default value; data: <empty>, at...