DSXchange

Hi, We have two server jobs to trigger the Webservice calls, both the web service calls will connect to the Oracle Database and populate the data using calcualtions in to different tables. After completion of the data population below are the problems we are facing 1.Normally one call will be comple...

Hi, We are using DRS Stage (ODBC) to connect DB2 . while reading from DB2 tables using sql we are not getting all the records, ie, last set of records are dropping. We never under stand why we are getting less number of records (usually 1500 records but last month the query extracted only 1150 recor...

Hi,

Can anybody tell me what is the Maximum size of data can be placed in a Dataset and SAS Dataset in Datastage Version 8?

Thanks for your help.


Thanks and Regards,
Sivasankar.Z

I think a solution for this. Take the year and month from the CurrentDate(). The date required is yyyy : (mm-1)only the value range between 02 and 12 : 01 . Use StringToDate function. Then use the function WeekdayFromDate(1st of thePrevious Month Date) if it returns 5 then it is friday which i am lo...

no we don't have any dimension tables.
the source data is coming from the flat file and we need to load in oracle.

the logic should be ,whenever the first of the previous month falls on friday only i need to filter the records. but how can i find the first of the previous month is friday? for example if my job runs on today 21-04-08 then i need to check the first of the previous month 01-03-08 is friday or not ....

hi, could you please help me to find is there any function to substarct months from a given date. i need to filter the records from the source data on a date column , if the 1st day of the previous month's date is friday then add 7 days to the particular date, filter those records which are not grea...

no the output will be string

you can use convert function to remove '-'.
syntax for the function is Convert('-','', Input_Date_Column)
and you can use substring function ,and syntax is
Input_Date_Column[1,4]:Input_Date_Column[6,2]:Input_Date_Column[8,2]

Hi all,
From the source the dates are coming like '1980-02-31','1995-02-31',
'2000-02-31', '2007-02-31' which is invalid because for Febrauary you will never have 31 days.
Can anybody tell me how to validate of the date?
Thanks for your help in this.

if it is on unix you can create a routine to find the count in the dataset. create the server routine and you can use the routine in the sequence by using routine activity you can find the count in the dataset. the code is given below. ! Call dsrecords for the required data set CALL DSExecute ( &quo...

hi actually the view had been created on the table only which had unique primary index . but our requirement is we have to load in to the views not in to the tables. can anybody tell me what is the difference between Teradata Api Stage and Teradata Enterprise Stage. can we load the data in to the vi...

Hi all, I am loading the data in to a teradata view fron the dataset using Teradata Enterprise Stage, but i am getting the following error. tdtPdwDA_PDW_LN1K: Error when checking operator: Table 'CXA486_CIDLIVE.DA_PDW_LN1K' does not exist! Cannot use truncate mode. Ensure that target is a TABLE obje...

thanks for your reply. i am getting the error because of passing the environmental variable in the sequence for the password and only for password i am getting the error. if i am leaving the password value in the sequence the job is running fine.for remaining all values i am using the $PROJDEF as th...

hi, i am using a job parameter in the job and i am running the job through a sequence using a environmental variables. but i am getting the following error and job gets aborted. oraBadaSample: Bad dboption list. Failed on Expected value for property "password" main_program: Creation of ste...