DSXchange

Yeah i got your point.. sorry for the late response.. the Buissness ppl r working on this.. thanks for your help

Hi Guys, I have 2 tables. Source table and a Cross refrence table. I am trying to find the records present in Source table but not in Cross refrence table. I am using Change capture stage. I have given Primary column as key field and based on the change code, i am getting the required information. (...

yeah Ray,, now i am getting your point...

on further analysis, i found that the data contains both YYYYMMDD and YYYYDDMM format..

Sorry to state the problem wrongly..

Hi Guys, I am reading data from SAP table. I need to read only those records which are having numeric value in a paritcular column. So, i used int(Col name) in the derivation. please guide me if i am correct. Because i am getting an abnormal termination error and the jobs gets failed. So, unable to ...

Sorry for the late reply.. its a long weekend here..

No idea Why we are not using OCONV and ICONV.. thats what we are doing..

As of now, the column comes only with YYYYDDMM format only. In the insert query, To_DATE() function is being used. Still, it is throwing an invalid month errror..

Hi Guys, The source column is a Char field. The target is a date field. In the server job, the transformation was taken care by the datastage itself. When the data is in the format of YYYYMMDD, the records are getting inserted. But if the record is in the YYYYDDMM format, it is throwing an error say...

i am pulling data from SAP table and loading it to Oracle stage.. In SAP table, when i check, these columns are NULL and i am not doing any transformation.. Its a direct pull but when i check the the Oracle stage, instead of empty string am getting only Null Value. ..

only some rows are null, some of them are having values with them.. i jus want to convert the ones which are coming as null to empty..

Hi Guys, I have a field coming with NULL values. Since i am working in Server job, i was not able to use NulltoEmpty() function. So, i wrote a if then else clause, but it is not working. Iam still able to see NULL values in the column. If IsNull(trim(columnName)) then '' else ColumnName I even tried...

Ya Ray,, there was no need to transform it like in the case of Parallel..

It worked out for me..

Hi Guys,

I want to convert a String Field to Decimal. But my project guidelines are not allowed to use OCONV & ICONV functions..

I tried using Seq function but it converts it to Numeric code value instead of Numeric value..

can somebody help me in this..

Cheers!!!!

I am pulling the data from a Mainframe table. When i am seeing the data through Datastage (View Data option), i am able to see proper data. But when i am seeing the file from the backend (Unix cat command), i am not able to see the data...

Hi Guys, My target file is a flat file and a oracle table. In the datastage, am able to see 10000 records got processed. But when i check it from unix side, the flat file shows more than 10000 (some 16k records)... One other thing is when i am seeing the data from the Datastage, the data looks fine,...

Yes, %yyyy%mm%dd solved the issue... it did not occured to me that it is the input format and not the output format required as i thought...
Thanks for your help guys.. you ppl Rock!!!!!!!!!!!!

@jwiles, i am trying to process it to a date. I used the left function to cut out the date alone and then i passed it to the StringToDate also.. Even then, i am getting the same error... :( StringToDate(Left(Trim(Colname),8),"%yyyy-%mm-%dd") Regarding the dashes/slashes, do we really need ...