DSXchange

The horizontal pivot stage appears to be reading data from 3 separate column as below Table 1. Input data for a simple horizontal pivot operation https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/hpivot_Example.html However my data is comma separ...

Hi,

I am using infosphere datastage v8.7 on aix.

can someone please suggest me how can I get expected output using datastage.

my input data:

id,id2,location
1, k12, CA, WA, NY
2,K8,VA,TX

expected output:

id,id2,location
1,k12,CA
1,k12,WA
1,k12,NY
2,k8,VA
2,k8,TX

Hi All, I have source datatype from oracle as 'date'. I am reading this as timestamp. I have another source from different table with datatype as 'date' and i am reading this as timestamp. in ETL transformer, I am using timestamptodate function to convert them to date. I am trying to achieve this in...

Enable return of multiple records from the reference input link resolved my problem.

Thanks
pavan

Hi All,

I have a input with 3 columns col A, col B and col C

For each of col A and col B combination, I have to write max(col C) to the output.

There can be duplicate data in the columns col A, col B and col C

can someone please let me know how do i achieve this in datastage.

Thanks
pavan

I am using lookup stage (lookup failure : continue). I have a main link and reference link. I can't switch the main link to reference link. input col ID: (main link) 223 223 223 223 reference link: 223 A 223 B 223 C 223 D lookup failure = continue in lookup stage current output: 223 A desired output...

Hi All, Can someone please suggest me how do solve this in datastage, I have a create_date, start date and end date. End date is nullable. create date and start date are not nullable. all 3 date columns are in the format mm/dd/yyyy (eg:7/24/2009) if create_date is >= start_date and create_date <= en...

is there any alternate approach convert and index functions?

can someone please let me know.

Thanks
pavan

I have input data coming in as below. can someone please tell me how do i replace Customer with Yamaha without changing rest of the data in the input.

input data:
Customer PIN Number


Desired outputdata:

Yamaha PIN Number

Thanks
Pavan

----------------------------- Input ------------------------------ 101 77604 60120 77624 102 80101 80101 80101 103 77562 - 77604 104 77562 77562 90210 105 77562 90211 77562 106 77563 90212 90212 the postal code1, postal code2 and postal code3 are nullable columns. ----------------------------- Desir...

There are actually 4 columns in the file Record = 1 ID postal code1 postal code2 postal code3: 101 77604 60120 77624 expected output: (write 3 records to the output since postal code is different in all the 3 records for this ID) ID postal code: 101 77604 101 60120 101 77624 Record =2: ID POSTAL Cod...

Hi All, I have a file 1 column and 3 records. Input record: postal code: 77604 60120 77624 expected output: (write 3 records since they are all different) postal code: 77604 60120 77624 Input record: (1 column, 3 record) 80101 80101 80101 expected output: (write 1 record) postal code: 80101 I have t...

I am new to datastage. I did not write any code for horizontal pivot in the past. Looking for thoughts.

Hi All, Can someone please tell me how do I accomplish the following in datastage 8.1 version. incoming record: colA COLB ColD 1 2 3 expected output: COL E: 1 2 3 incoming record: colA COLB ColD 1 1 1 expected output: COL E: 1 incoming record: colA COLB ColD 1 1 2 expected output: COL E: 1 2 incomin...

Hi all,

The output column length has to be 8 bytes. If the data in the incoming column (say xyz) is less than 8 bytes then I have to append leading zeros (to make to equal to 8 bytes) before writing the output file.

can someone please let me know how can achieve this in datastage.

Thanks
pavan