DSXchange

Hi Ray

Thanks for your reply

No Constraints used direct mapping

Hi all, I am trying to derive from source field whose datatype is varchar2 i.e, for example, Inlink.field0 Mar 08 Jun 08 Jul 08 Outlink.Field1 Outlink.Field2 MARCH 2008 JUNE 2008 JULY 2008 I am trying to achieve using Oconv & Iconv as column derivation Oconv(Iconv(UpCase(Inlink.field0),"D M...

Hi Ray,

I am taking Field0 as the key column in target database only but it is not unique. its value is repeating. Also I want both the records in
Inlink.field1 and Inlink.field2 into
Outlink.field1_1 and Outlink.field2_2 respectively.

I want to pass the two records present in single column into single row. here is the sample data input table field0 field1 field2 101 1 1000 101 2 2000 output table Inlink.field0 Inlink.field1_1 Inlink.field2_2 101 1000 2000 I tried for in column derivation as.... If Inlink.field1=1 then Inlink.fiel...

Hi all, I want to pass the two records present in single column into single row. here is the sample data input table field0 field1 field2 101 1 1000 101 2 2000 output table field0 field1_1 field2_2 101 1000 2000 I tried for in column derivation as.... If field1=1 then field2 else 0 for field1_1 If f...

Hi all Thanks for your suggestions, I dont want to pass the NULL value to the target because target column is key column. I had created target database in oracle whose key column is NOT NULL and its a primary key. then i simply transformed the input link to output. Its not accepting the NULL (obviou...

Hi all Thanks for your suggestions, I dont want to pass the NULL value to the target because target column is key column. I had created target database in oracle whose key column is NOT NULL and its a primary key. then i simply transformed the input link to output. Its not accepting the NULL (obviou...

Hi all Thanks for your suggestions, I dont want to pass the NULL value to the target because target column is key column. I had created target database in oracle whose key column is NOT NULL and its a primary key. then i simply transformed the input link to output. Its not accepting the NULL (obviou...

Hi all,

I am trying to avoid null values for Name field, I am doing simple transformation from oracle database to another oracle database through an ODBC-->TRF-->ODBC.

can anyone suggest me to avoid null values in NAME Field(Varchar).

Thanks in Advance

I had extracted the data from sqlserver through Odbc stage and transformed to Oracle database table through transformer to another Odbc stage, Its a straight pull from source. 7 lakhs records has transferred to oracle table with the following warning for 10 columns SQLColAttributes(Field1) gave Meta...

I had dropped metadata from the link's and then deleted the job. Atlast the job has been deleted.

Thanks for your suggestions.

please tell me how to unlock the job from datastage administrator.

thanks in advance

While I am trying to delete a job that ran for 10 hours, in vain. I am not able to delete it. the message from datastage is.. Unable to delete the item Cannot get exclusive access to log for job job_name Can any one tell me how to delete the job Note: when i am trying to view the log details, direct...

Hi all, I am trying to transform the data from text file to ORACLE10g database, its simple transformation, no manipulation is done. I am using SEQ->TRF->ODBC stages to do this. I am enabling create table in ODBC Stage. Its creates the DATE datatype for DATE FIELDS. If I am creating the Oracle table ...

Yes, I have UNIX based ODBC driver for MS-ACCESS.
Can you please tell me how to install the driver

if I am out of topic excuse me and suggest some tips

thanks in advance