DSXchange

I got only this error message, Just after initializing the Job.

Log:

main_program: Dump:
After the above statement I got the error.

Hi All,
I'm getting the below error message in Datastage 8.5.

"Parallel job reports failure "

I tried compiling, force compiling, re-Importing.dsx, renaming the Job. No luck can you please help?

My output metadata matches with Table structure...When I use the Option Immediate it work's fine...

Hi All,

I'm trying to use "BULK" Access method in Teradata connector To read huge volume of data...I'm getting the below error message...

Error:
Properties /Usage/AccessMethod, /Connection/ClientCharacterSet: Incompatible property values[Output link 0]

Can you please help....

Thanks Ray!!!

I got the Logic to fix the issue...

PrevVal CurrVal
CurrVal 123:456

PrevAct CurrAct
CurrAct If Currval=PrevVal Then PrevAct Else PrevAct+1


Thanks Craig...

So We need to get the
0
1
1
Using the transformer stage by comparing the prev and Curr record and then do the Looping?

yes I have Datastage 8.5 Version...

Hi Criag, Please find the output from Aggregator Stage... ITM_INST Start Ts PTY_ID End Ts 123 1/1/2008 456 12/31/9999 123 1/1/2011 567 12/31/2011 When I group by ITM_INST and PTY_ID first 3 records and last records is considered as one group and 4th records as separate record.... I have overlap...

Thanks Craig... First I tried with Aggregator Stage using Min(Start date) and max(end date) But it doesn't return correct values... I have a over lap Second option using Stage Variable in Transformer by comparing prev row and current row I have rows 0 1 1 0 0 I'm not sure how to to split the records...

Hi All, I have a scenario where I need to group the records based on the Order... Input Records ITM_INST Start Ts PTY_ID End Ts 123 1/1/2008 456 12/31/2008 123 1/1/2009 456 12/31/2009 123 1/1/2010 456 12/31/2010 123 1/1/2011 567 12/31/2011 123 1/1/2012 456 12/31/9999 In the above Input records I nee...

Hi All,

Can I use the Datastage parallel Job to Select teradata rows from Table A and update the Same table column in one single Job?

I will be sorting and update the end timestamp based on previous rows in the Job.

I have millions of rows in the Table... Please let me know your thoughts. Thx.

Hi All, I have a scenario where I need to replaces all the rows with Zero into Single space... Invalid Rows Eg: 0 00 000 0000 The column is defined as Varchar(20) so it can have any combination of Zero values starting from 1 to 20 zeros I need to remove all the rows where it has Zero's as defined ab...

What is the Best way to handle NUL from the Source?

Below convert function helped me to avoid the NUL values.

Convert(Convert(' ABCDEFGHIJKLMNOPQRSTUVWXZYabcdefghijklmnopqrstuvwxyz0123456789','', Trim(colname)),'', Trim(colname))

When I open the file in Notepad++ one of the column show as

Kumar[NUL][NUL]
Bala[NUL][NUL]

It looks like ASCII characters, I tried filter option in sequential file

tr -c '\0\ '' But it didnt work