DSXchange

Hi Jwiles,

Thanks.
Yes I do not have column on which I can sort and partition.
But what could be the reason for such behaviour of the job?

Thanks,
Chetan.C

Thanks ray.
But can you please let me know what could be the problem?

Hi, My job design looks like this externalsourcestage--->transformer---sequential file. The script in External source stage give output in on single column like below. sample1.txt 100 sample2.txt 150 .. . In the transformer I am deriving filename by the below expression in stage variable. index(DSLi...

Hi,
I have data like this.
Dataset,
col1,col2,col3.

Table:
tab1,tab2,tab3.

My output should be
col1,col2,col3,tab1,tab2,tab3.

There are no keys in both data on which i can join.

Please let me know if further clarification required.

Thanks,
Chetan.C

Hi, I have two input columns col1 col2 Data Filename In the external filter stage i am calculating byte size of col1. I want my output to be Col1 Col2 Byte_size(Data) Filename In the external filter stage is it possible to perform operation only on one column? Thanks, Chetan.C

Hi, I have multiple XML's coming in after some parsing through Java Transformer. I have to create a large XML out of these and get byte size of each XML and also get byte offset of each XML in the large XML. This larger XML has to be compressed and stored. Can i do this in Datastage .I'm on 8.7 para...

I need one sequence that can be used across all the jobs.

Thanks,
Chetan.C

Hi Craig,

What is the best way to do this?
I do not have the freedom to save in any table so i have to store this value on file system.
This file needs to be update after each run and the next run must Pick up this value+1.

How can I implement it?

Regards,
Chetan.c

Hi, I need to generate a run id for each run the of the job. For the next run the value must be incremented. The approach i know is storing the value in the table and calling select max query in unix script and extract that data in User variables and use it in job as job parameters. Is there any oth...

Hi, I'm trying to understand the Surrogate key generator stage. Below is my job design to test the Surrogate jey generator stage with Oracle Sequence. Surrogate_key_gen----->Flat_File/Peek. What i'm trying to do is to configure the Surrogate key stage to generate the key from Oracle sequence and vie...

Yes right.
I am using column import itself, it was typo.

Now splitting into columns at code itself.

So column export is not a good option?

Thanks,
Chetan.C

Hi,
Please try this.
Sequential file stage-->output tab--->Format tab--->Field defaults.
On the right side you will see "Available properties to add".
Select Null Field Value.

Thanks,
Chetan.C

Currently trying out column inport stage.
But want know how recieve the data as seperate columns from the Code.

Thanks.

Hi All, I have a java transformer stage which is giving output as below. col1|col2|col3... data1|data2|data3| . . I want to recieve this data and use this for a join. Currently the java code is giving the output as a string. Do I need to split data there into different columns or split string later ...