DSXchange

First one,yes i am working on it.

When we used decimal, decimal values are not getting inserted. Hence only we have used float. So can you suggest which metadata needs to be used for a decimal value.

The issue is fixed. changed the metadata from Float to Double.

Thanks !!!!!

So, Ray there is no solution to this problem?

Thanks!!!!

I realized that so i restored my laptop to a previous restoration point.. now everything is fixed,..still like to know how to find out which dll got corrupted..

Cheers!!!!

Hi Guys, My source is a flat file. My target is a oracle table. The column in question is of metadata Number(22,12) in oracle. In datastage, i am using the metadata float 22,12. Now the problem is, in the source file iam getting the value 46.536. But in the oracle table that value is getting inserte...

any info or warning message stating default value used in the logs? The error i was getting was "Conversion error. Data will be lost.". @chulett, thats why i was converting to decimal to do the conversion. But i guess, i will go ahead with: DateOffsetByComponents(sourcedate,year_offset,mo...

Hi Guys, I have a date(2011-01-23) coming from source. I need to get the same date for previous year. I am trying to get the convert the date to String and retrieve the year and minus -1 and concantanate back. DecimalToString(StringToDecimal(DateToString(DSLink21.Curr_Yr_Actl_Sales_Dt,"%yyyy-%m...

I have given it the following way.

(SourceCol) Date >= (LookupCol.StartingDate) and
(SourceCol) Date <= (Lookupcol.TerminationDate)

Hope i made myself clear.

Hi, I have a range lookup. The source has a date coulmn. The lookup table has 2 date column. The date coulmn in the source should lie in between dates in the lookup table. I have checked the range in the lookup and gave the source column to be in between lookup dates. The source dates are in between...

Thanks Priyadarshikunal.,,, preserve type was the one i was looking out.

Hi Guys, I want to get the maximum date. So, I converted the date to String (YYYYMMDD) format. Then i used Max() function in the aggregator stage. But instead of coming the format of YYYYMMDD format i am getting as 2.01205e ( which is 20120501). I am using Datastage 8.5. Could somebody help me out h...

Hi Guys, I need a help on a logic. I have records with the below metadata. Date Model Brand Monthly_Count Daily_count It has records for all the date of a month. For the last date of the month, i have to sumup the daily_count for the all the dates execpt the last date and subtract that with monthly ...

Hi Guys, I have input which has 9 decimal values 0.123456789 But when i am viewing the data or writing it to Database, I am getting only 6 digits. The metadata i have kept as Float 15(9). 0.123456 Can somebody tell me what i am doing wrong. My Bad,, Database is having only Decimal10(6). Cheers!!!!

Hi Guys, I am importing a sequencer from dsx file. But in designer and manager, i am seeing two sequencer with the same name. When i delete one sequencer, both of them are deleted with a prompt "one job is missing in the project". Could somebody throw some light in this issue. Cheers!!!!!!...

Hi Guys, My source is a Oracle Database. The Column's metadata is Varchar(50). So, in datastage i have kept the datatype as Varchar and lenght as 50. But i am able to see only partial data when i am seeing it from Datastage. If i increase the length to 150, then i am able to see the complete data. C...

Hi Guys, I just need to call a stored procedure from Datastage. There is no input parameters and output parameters to the Stored Procedure. Oracleconnector ----- > STP I am getting the following error "error occurred in call to orphcallactiveplugininitialize " Can some body help me out her...