DSXchange

We have nightly back-ups of our production environment. The projects (legacy side only I believe) are backed-up. So, when I started having problems yesterday... I asked the network folks to restore the back-up from Nov 15. Prior to them backing up, I dropped and re-created the same project (DwProd) ...

Thanks for the reply. I ran the syncscript.sh and it deleted all the jobs... Now I cannot see the jobs in director as well... I rant the script for diagnosis and it showed 936 issues need to be fixed. I ran the resolve script and it said all 936 issues have been fixed. Earlier I was able to see the ...

Hello: I had issues with my project this morning so decided to restore from the tape (networking group) from Sunday night back-up. I dropped and re-created the project (DwProd)...the folks restore the project. But I cannot open any job. I can see the job in Director and run them fine. But when I try...

Works great. Thank You.

I have a varchar column with alpha numeric records. I want to insert a decimal (period) after the first 3 characters. How do I accomplish this in the transformer? Example Current Diagnosis_Code --------------------------- H13132D 78888D 43834 Converted As Diagnosis_Code -----------------------------...

This worked:

StringToTimestamp(CLAIM_ST_DT, "%mm/%dd/%yyyy") : " 00:00:00"

Thanks for the reply. Yes, I have set the scale to 2 in the datastage job. The SQL Server source column data type is Varchar(30). Could you please elaborate on what you mean by format string in StringToDecimal(). Here are the things I have tried: Implicit conversion: Truncates the decimal places (Or...

I am pulling ClaimAmt from SQL Server and the datatype is Varchar(30). I am loading this into oracle table with Decimal (38,2) datatype with 2 decimal places. I used StringToDecimal function and Implicit conversion in the transformer but it does not work the way I want to see. It does not put the 2 ...

I have spent considerable time trying to fix that but get error message. I have Claim_St_Dt coming as Varchar from SQL Server (Here is how the date comes as "08/22/2013". Just date no time. I want to insert this into Oracle table with Timestamp datatype. 50% of the rows are NULL for this c...

Here is how the data for that column is
6/14/2014 16:07
and
I want to load it in Oracle as Timestamp (Date) 'YYYY-MM-DD HH24:MI:SS'

I have "NewDate" column coming from SQL Server as VarChar with the following format:
MM/DD/YYYY HH:MI
6/14/2014 16:07

I want to load this into Oracle table using Timestamp datatype (Its Date in Oracle).

Any pointers/help is appreciated.

Thanks!!

Thanks!!

Hello: I have a varchar column: GradeValue and the source data has "*" <asterisk> in some rows. Example: 145* 12* 9* I want to remove that "*" sign in the transformer stage. I am using FTP stage to get the source records and do some validation in the transformer stage. What funct...

Thank You!!

Hello, I have the following script in my batch to load month and year dynamically. I pass the below parms to jobs in the batch. Current_Month = OCONV(@Date,"DM") Current_Year = OCONV(@Date,"DY") However the result is Current_Month = "9" and I would like that to be "...