DSXchange

Thanks ArndW

It worked I removed the Trim function

Thanks again for your help

Hi All, I am trying to compile a job but getting some compilation error message Error Compiling Parallel Transformer when i clicked more button I see this Output from transformer compilation follows: ##I TFCN 000001 10:47:13(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyri...

Hi ,

I need help in writing the shell script to ftp .csv files from cognos server to Datastage server . Which command do I need to use . I appreciate your help

Thanks

Rajeev

I am sorry Ray.

Hello, I have two fields rep_year and rep_mon from source and time_dim as a look up table looking up on these two fields , but the time_dim_id should be generated as below : If rep_year is 2009 and rep_mon=1 then the time_dim_id should be 20090101 (first day of the month) rep_year is 2009 and rep_mo...

Hello All, I am trying to load the data from DB2 into target which is also a DB2 data base . But when I ran this job I am getting weird error . Error DB2_UDB_API_34: When processing argument -inlinkpropsWhen processing input link property list: { Bunch of columns related to the other table and at th...

Hi All,

We are planning to implement syncsort in our project i want to know more informaiton can anybody help me out

Thanks

Hi all, I am facing the problem in extracting the data from the flat file as it is my source i am getting warnings for few columns the warning says as below: [b]read_delimited() - invalid quotes, row 8098 column LocationNameLong = "JEAN NUZZI INTERMEDIATE SCHOOL " I have tried using oconv ...

hi ray

I did not understand you point what exactly you mean to say i know hash file is used to remove duplicates but i am getting different warnings

I am using distinct key word in the sql query and i am moving the same to the hash file is that the problem i am getting

Thanks

I have checked the data path and also the input and outputs everything is fine but still i am getting the same warning

Thanks

Hi , Thanks for the reply here is my job design : ODBC STAGE(SOURCE FILE) -------> HASH FILE-------------->TRANSFORMER STAGE----------->ODBC STAGE(TARGET) AND I HAVE ONE LOOK UP ODBC STAGE I am getting everytime some weird warning when i ran for the first time i got abnormal termination of stage and...

Hi All,

I am facing the problem with the hash file it says Abnormal termination of Transformer stage and its not reading the data from the hash file , as it is writing into the hash file.

What could be problem i don't understand

I need your helpto resolve this

Thanks for the input

rajeev

Hi All, I am trying load the staging table where my source is sequential file and i am getting phantom warning as "DataStage Job 3 Phantom 3988 Program "JOB.1414850643.DT.1430025947.TRANS1": Line 272, Nonnumeric data when numeric required. Zero used." I have checked everything i ...

Hi Deepak, I tried with another flat file but it just populated fine , but when i try to populate the table why i am getting the warnings, I do not have the data which can be processed by monthly i just have to dump the rows which represent the year 2004-2005 from the source i.e sequential file. our...

I have checked the source and target lengths as well as the data types are same is there any other way to do this

Thanks for you help