DSXchange

Hi, My job is failing while reading data through file_connector stage, please help me to resolve the issue. Error: File_Connector_10,0: An exception occurred: com.ascential.e2.common.CC_Exception: Failed to parse row 1,138,067 (org.apache.avro.AvroRuntimeException: java.net.SocketException: Connecti...

Hi While i am trying to convert the string to timestamp getting below error. Caould some one help to me. Numeric value first converting into string and then that string value converting to timestamp. using format in the transformer ::stringToTimestamp(var1,"%yyyy-%mm-%dd %hh:%nn:%ss") Erro...

You mean after using funnel stage, add remove duplicate stage ?

Hi All,

We can do Union all condition with funnel stage, how we can implement the union logic in datastage ?, can some one help.

Hi, I am trying to load the data into hive data base though hive connector getting below error, still I am using my data type length is 250 in datastage and in hive provide the STRING as data type. Hive_Connector_24,0: java.lang.StringIndexOutOfBoundsException at java.lang.String.substring (String.j...

No It is in bigdata location... and getting below error. File_Connector_0: java.lang.NoSuchMethodError: org/apache/http/conn/scheme/Scheme.<init>(Ljava/lang/String;ILorg/apache/http/conn/scheme/SchemeSocketFactory;)V at org.apache.http.impl.conn.SchemeRegistryFactory.createDefault (SchemeRegistryFac...

Hi,

Any one worked with the Big Data, AVRO, ORC, Sequence through FILE connector stage. IF Yes tell me how to develop and required installations.

Hi All, I am getting below error. File_Connector_14: com.ascential.e2.common.CC_Exception: java.io.FileNotFoundException: /EDMBD/CDH/avro_sch.avsc (No such file or directory) But providing the Host,port,user, filename, avro schema but still job failing. Eventhough schema file in a location, job show...

Hi,

in my sequencer i have 5 jobs, if my 4th job fails, after reset the job, sequencer should be rerun from 3rd job not from 4th job.

Please some one give an idea how to achieve this activity without using routine.

Hi,

I want to select the required column dynamically at run time.

Ex: out of 5 columns, may i will select any column at runtime, output should be only selected column data..

Hi I am getting below warning can any one can explain what is the meaning and how to resolve the issue. 1) SqlTb_Stg_Mstr,0: Invalid character(s) ([x8D]) found converting string (code point(s): SLA_000215_D[xC3][x8D]AS DE CINE) from codepage ASCL_MS1252 to Unicode, substituting. 2)APT_CombinedOperat...

Hi, scenario: i have 5 columns A,B,C,D,E when month 1, want to populate A,B,C,D,E when month 2, want to populate A,B,D,E when month 3, want to populate A,B,E but 3 output file name is should be same please tell me how to do this scenario I tried once. but if i use same name for 3 outputs file is cur...

Hi, We are mapping data from sql to sql and taken a reject link from Transformer for reject data, but the thing is rejecting the data without any logic in transformer and it's converted into the reject link. we have 4 keys. Those are Varchar only. Please tell some one how it's happening, i never see...

Hi i experimented will do with below logic even fine.

( Left(column,1) ='1' and Left(column,2) <>'12')

but looking any other way we can filter.

Hi, Please explain the situation resolvation Now i am getting data -1,-12,-13,-1,-1 data started with 1 should be flip sign, if getting '-' should be '+' or '+' should be'-'. except data start with 12, remaining start with 1 should be change. i have to get the data like +1,-12,+13,+1,+1 How to do in...