DSXchange

it would be the hash partioning based on the keys .Try this

hi all, I am using the dataset created from prior joba and inserting the records using the oracle stage with user defined SQL with write method as upsert.In datastge direction monitor tab,it shows the records are inserted .but when i query in database by select ,unable to find records.Could you plea...

try delete some records in DB.mayresolve this issue

Hi,

While i am running the job, some times i get this status DS.Bad value 2.but job in not aborting.Please help me on this

Hi,

Need some info abou date validation. iam getting Date in DD-MMM format from soure file.i need to check whether it is valid or not please help on this.

Thanks in advance

ok i wil check it out

hello,

just to onfirm . is valid works for such incoming value 15:00 CET

Thanks

Hi All,

In one of my column, i am geting the values as 15:00 CET. i need to check whether it is a valid time or not . how to do this.please help me

Thanks in advance

also i getting special characters some filedls i.e is german data

hi

My job is running with the warning -"Cannot read name".
and also iam not taking column names though it is mentioned in xls.i am reading the atual data by specifiying cells- A2 in options.

Hi,

My soure is xls file with 80 columns. iam able to read data by java client stage. but i get a warning -"Cannot read name".Please help me out .

Thanks

hello,

could you please elaborate on how you need data with both input and output.

Hi All, I am facing below warning is my application development. Could you please someone help on this and how to resolve it. Warning: main_program: Invalid character(s) ([xA5]) found converting string (code point(s): LoadID[x00][x00][xA5][x02][x00][x00]) from codepage UTF-8 to Unicode, substituting...

Hi ,

we are using merge stage to identify the insert and updates.its working fine with fewer records.in case of more records it doesnot identifies the inserts ad updates correctly.we are not using any partition technique and running on two nodes.please help me.

hi

use below condition in stage variable

if trim(col1)= trim(col2) then col1 else if trim(col1)<>trim(col2) then col:col2 else stagevariable name.